object statistics

[Roshan]

Oracle Database 11.2.0.4
Red Hat Enterprise Linux 5.8

Hi Erman,

Is there a way I can verify object statistics?

I have tried this command:

SQL> SELECT PARTITION_NAME, STALE_STATS   FROM DBA_TAB_STATISTICS WHERE TABLE_NA                                      ME = 'GCI_PREORDER'      AND OWNER = 'L2TCP' ORDER BY PARTITION_NAME;

PARTITION_NAME                 STA
------------------------------ ---
                               NO



Regards,

Roshan

[ErmanArslansOracleBlog]

Check this note (script) -> Script: To check Tables for Statistics (Doc ID 1020188.6)

[Roshan]

Thanks a lot :)