========ORACLE索引的扫描次数
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
========ORACLE表的扫描次数
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 '%TABLE%'
and d.sql_id = h.sql_id group by d.object_name, d.operation, d.options
order by 1,2,3