SQL> select * from user_tab_modifications;
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU
------------------------------ ---------- ---------- ---------- --------- ---
EMP
14 0 0 16-OCT-03 NO
If a monitored table has been modified more than 10%, then these
statistics are considered stale
Analyze the tables whose statistics have become stale using the following command:
Step 6:
-------
Query dba_tab_modifications to check whether the table has been analyzed
or not?
SQL> select * from user_tab_modifications;
no rows selected
No rows in dba_tab_modifications indicates that the table is analyzed.
Partager