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

Attack_on_Jager 發表於 2021-08-10
Oracle 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;



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69992972/viewspace-2786184/,如需轉載,請註明出處,否則將追究法律責任。