Oracle table statistics

[Former Member]

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.

[Former Member · Accepted solution]

Hi Shanaka,

As far as I know that the DBA_TAB_MODIFICATIONS table used to collect quality of statistics value by SAP, also. There's only one exception that at the first step, without paying an attention to the DBA_TAB_MODIFICATIONS records, the system creates new statistics by using "-f stats -t all" parameters. At the second and further steps, new stats will be created for the tables that are need to be collected.

In short, because of the DB20 transaction reflects DBA_TAB_MODIFICATIONS table to store quality of the table stats, both values should be same.

In addition to the information above, you can read the notes, below;

Note 588668 - FAQ: Database statistics

Note 408527 - Checking the statistics using DBA_TAB_MODIFICATIONS,

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

HI Orkun,

Thanks for the reply,

I think in note 588668 question number 28 is relevant to my query thanks for sharing this and note 408527 can use to create user define threshold to collect statistic on rapidly updating tables.

Will check them .

Thanks and best regards,

Shanaka.