As Oracle 10g STATISTICS_LEVEL parameter needs to be "Typical" to keep Monitoring of all tables DML i.e (Insert ,Update ,Delete) , i have got Oracle 10g and STATISTICS_LEVEL is "Typical" but still the monitoring of tables is not updated , what could be reason for it.
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
SQL> conn scott/tiger
Connected.
SQL> select *
2 from tab
3 /
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE
SQL> conn sys/sys as sysdba
Connected.
SQL> select * from all_tab_modifications
2 where table_owner='SCOTT'
3 /
no rows selected
SQL> select * from all_tab_modifications
2 where table_owner='SCOTT'
3 /
no rows selected
SQL> select * from dba_tab_modifications
2 where table_owner='SCOTT'
3 /
no rows selected
SQL> select * from user_tab_modifications
2 where table_name='T'
3 /
no rows selected
SQL> disconnect
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options