Offer at PACKT

Good chance to grab your Oracle 11g R1/R2 Real Application Clusters Essentials at PACKT

Find whether stale statistics

Column STALE_STATS from *_tab_statistics. click here for description

SQL> select table_name,object_type,num_rows,last_analyzed,stale_stats from user_tab_statistics;

TABLE_NAME                     OBJECT_TYPE    NUM_ROWS LAST_ANAL STA

------------------------------ ------------ ---------- --------- ---

ADDRESS                        TABLE                 0 08-NOV-12 NO

GANIBHAI                       TABLE                10 08-NOV-12 NO

T1                             TABLE             10000 23-JUN-12 NO

T1_BACKUP                      TABLE             20700 27-JUN-12 NO

T2                             TABLE               999 23-JUN-12 NO

TEST                           TABLE               298 14-SEP-12 NO