打开监视:
alter index test1
monitoring usage
此命令以后,如果对表进行操作后,就可以查v$object_usage表看是否index用到。
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING
---------------- ------------------ --- --- ------------------- -------------------
MC C01 NO YES 02/17/2005 14:41:41 02/17/2005 14:43:46
关闭监视:
alter index test1
nomonitoring usage