实验环境

搭建平台：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;