索引监控

SQL> alter index sys.test1_objectid monitoring usage;       --开启监控

SQL> SELECT * FROM V$OBJECT_USAGE;

INDEX_NAME           TABLE_NAME MON USE START_MONITORING    END_MONITORING
-------------------- ---------- --- --- ------------------- -------------------
TEST1_OBJECTID       TEST1      YES YES 04/16/2013 15:02:06

SQL> alter index sys.test1_objectid nomonitoring usage;     --关闭监控

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26655292/viewspace-758601/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26655292/viewspace-758601/