监控索引是否使用
首先执行如下语句：
alter index INDEX_NAME monitoring usage;
再做个可能会用到此索引的查询。next,
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MONITORING USED START_MONITORING END_MONITORING
------------------------------ ------------------------------ ---------- ---- ------------------- ----------------
SQL> alter index IDX_DO_LEAF nomonitoring usage;
运行无结果
SQL> select * from v$sql_plan where object_name = 'IDX_DO_LEAF' and object_type = 'INDEX';
首先执行如下语句：
alter index INDEX_NAME monitoring usage;
再做个可能会用到此索引的查询。next,
SQL> select * from v$object_usage;
INDEX_NAME TABLE_NAME MONITORING USED START_MONITORING END_MONITORING
------------------------------ ------------------------------ ---------- ---- ------------------- ----------------
SQL> alter index IDX_DO_LEAF nomonitoring usage;
运行无结果
SQL> select * from v$sql_plan where object_name = 'IDX_DO_LEAF' and object_type = 'INDEX';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24387280/viewspace-681792/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
Oracle执行计划
请登录后发表评论
登录
全部评论
