该脚本通过DBA_HIST_SQL_PLAN和DBA_HIST_SQLSTAT视图查看数据库中访问某个索引的次数以及索引访问的类型。
[oracle@maa3 ~]$ cat showindex.sql column OBJECT_NAME for a30 column OPERATION for a25 column OPTIONS for a25 select d.object_name, d.operation, d.options, count(1) from dba_hist_sql_plan d, dba_hist_sqlstat h where d.object_owner <> 'SYS' and d.operation like '%INDEX%' and d.sql_id = h.sql_id group by d.object_name, d.operation, d.options order by 1,2,3 /
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25462274/viewspace-2120565/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQLHC
请登录后发表评论
登录
全部评论
