Oracle table statistics

[#1]

Dear All Members,

Is there any way where we can check whether current statistics in table are outdated in oracle? In OTN i found using view "DBA_TAB_MODIFICATIONS" we can gather timestamps of statistics

But can we use this to compare the quality of statistics in DB tables?

Regards,

Shanaka.

[fidel_vales]

Shanaka Chandrasekera wrote:
Dear All Members,
Is there any way where we can check whether current statistics in table are outdated in oracle?

First you have to define "OUTDATED" and this is the main problem a lot of people has.

do you mean that the statistics were calculated long time ago? (to be define what is "long time ago)

of do you mean that the table content has changed a lot? (also to be define what "a lot" means)

The first point should NOT be used (see note 825653 - Oracle: Common misconceptions point 7)

The second one is already used by BRCONNECT as already mentioned and, by defaut, it check that the change is bigger than 50%. for details check the documentation Internal Rules for Update Statistics