【TUNE_ORACLE】列出走了INDEX FULL SCAN的SQL参考

实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考select c.sql_text, c.sql_id, b.object_name, d.mb  from v$sql_plan b,       v$sql c,       (select owner, segment_name, sum(bytes / 1024 / 1024) mb          from dba_segments         group by owner, segment_name) d where b.sql_id = c.sql_id   and b.child_number = c.child_number   and b.object_owner = 'TEST'   and b.operation = 'INDEX'   and b.options = 'FULL SCAN'    --INDEX FULL SCAN是一种性能较低的扫描方式   and b.object_owner = d.owner   and b.object_name = d.segment_name order by 4 desc;