为一个索引启动索引监视功能,等待一个该索引的完整工作周期(某些索引可能一周或一个月才能使用一次),然后通过某个查询查看该索引是否被使用,最后禁用索引监视功能。
SQL> alter index reg_id_pk monitoring usage;
Index altered.
SQL> select index_name, table_name, used from v$object_usage;
INDEX_NAME TABLE_NAME USE
------------------- ---------------------------------------- -------
REG_ID_PK REGIONS NO
SQL> select * from regions where region_id=1;
REGION_ID REGION_NAME
------------------ --------------------------------
1 Europe
SQL> select index_name, table_name, used from v$object_usage;
INDEX_NAME TABLE_NAME USE
------------------- ---------------------------------------- -------
REG_ID_PK REGIONS YES
SQL> alter index reg_id_pk nomonitoring usage;
Index altered.
SQL>
SQL> alter index reg_id_pk monitoring usage;
Index altered.
SQL> select index_name, table_name, used from v$object_usage;
INDEX_NAME TABLE_NAME USE
------------------- ---------------------------------------- -------
REG_ID_PK REGIONS NO
SQL> select * from regions where region_id=1;
REGION_ID REGION_NAME
------------------ --------------------------------
1 Europe
SQL> select index_name, table_name, used from v$object_usage;
INDEX_NAME TABLE_NAME USE
------------------- ---------------------------------------- -------
REG_ID_PK REGIONS YES
SQL> alter index reg_id_pk nomonitoring usage;
Index altered.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11411056/viewspace-733764/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11411056/viewspace-733764/