Last Analyzed of Particular Table

To check  last analyse particular table :

1. To check particular user of tables

        SQL>select owner,tables_name,last_analyzed,sample_size from dba_tables where owner='RPM12' order by table_name;

2. To check particular Last analysed table

   SQL>select  num_rows,last_analyzed,sample_size,chain_cnt,partitioned,owner,table_name from                  dba_tables where table_name='ITEMMASTER';

3. Checking Indexes

     SQL> select owner,table_name,index_name,SAMPLE_SIZE,LAST_ANALYZED,BLEVEL from dba_indexes where owner='RPM12';

4. execute sql script the stats gather table

     SQL>exec dbms_stats.gather_table_stats('rpm12','itemmaster');

Note: to execute this statement  after again check table_last analyzed than get result.

5.finally check the last analyzed of table (data)

    SQL>select  num_rows,last_analyzed,sample_size,chain_cnt,partitioned,owner,table_name from                   dba_tables where table_name='ITEMMASTER';