Oracle11g : Monitoring table or index

To monitor a table :

SQL> ALTER TABLE <my_table> monitoring;

To monitor an index :

SQL> ALTER INDEX <my_index> monitoring;

To flush statistics in the dba monitoring table :

SQL> exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;

To see monitoring info in dba tables :

SQL> select * from dba_tab_modifications;

To stop monitoring, use: alter table xxxx nomonitoring;