为一个索引启动索引监视功能，等待一个该索引的完整工作周期（某些索引可能一周或一个月才能使用一次），然后通过某个查询查看该索引是否被使用，最后禁用索引监视功能。
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博客 ” ，链接：https://blog.itpub.net/11411056/viewspace-733764/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
共享锁与排他锁试验结论
请登录后发表评论
登录
全部评论
