【TUNE_ORACLE】列出索引被哪些SQL引用的SQL参考

实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考select a.sql_text, a.sql_id, b.object_owner, b.object_name, b.object_type  from v$sql a, v$sql_plan b where a.sql_id = b.sql_id   and a.child_number = b.child_number   and object_owner = 'TEST'   and object_type like '%INDEX%' order by 3, 4, 5;