Oracle脚本(Oracle Scripts) – 查看索引访问次数及索引访问类型

该脚本通过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博客 ” ，链接：http://blog.itpub.net/25462274/viewspace-2120565/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25462274/viewspace-2120565/