auto optimizer stats job status: CLIENT_NAME JOB_STATUS JOB_START_TIME JOB_DURATION -------------------- ------------------------------ ----------------------------------- ------------------------------ auto optimizer stats SUCCEEDED 20-SEP-12 22.01.03.409831 EUROPE/LO +000 01:35:18 collection NDON Last analyzed status: SQL> select table_name,last_anaLYzed from dba_tables where owner='YUKONRRT'; TABLE_NAME LAST_ANALYZ ------------------------------ ----------- YUKONRRT_OLD_STATS 12-SEP-2012 CVLAN_PERFORMANCE_DATA 18-SEP-2012 DLM_PERFORMANCE_DATA 17-SEP-2012 SQL> SELECT TABLE_NAME,LAST_ANALYZED,NUM_ROWS FROM DBA_TABLES WHERE TABLE_NAME='DLM_PERFORMANCE_DATA'; TABLE_NAME LAST_ANALYZ NUM_ROWS ------------------------------ ----------- ---------- DLM_PERFORMANCE_DATA 17-SEP-2012 2319988060 SQL> select TABLE_NAME,PARTITION_NAME,INSERTS,UPDATES,DELETES,TIMESTAMP,TRUNCATED from USER_tab_modifications where table_name='DLM_PERFORMANCE_DATA'; TABLE_NAME PARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU ------------------------------ ------------------------------ ---------- ---------- ---------- ----------- --- DLM_PERFORMANCE_DATA 247368382 0 0 20-SEP-2012 NO DLM_PERFORMANCE_DATA SYS_P2663600 3596603 0 0 21-SEP-2012 NO