【TUNE_ORACLE】列出返回行數較多的巢狀迴圈（NESTED LOOPS）SQL的SQL參考

實驗環境

搭建平臺：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL參考

select *

  from (select parsing_schema_name schema,

               sql_id,

               sql_text,

               rows_processed / executions rows_processed

          from v$sql

         where parsing_schema_name = 'TEST'  --使用者名稱

           and executions > 0

           and rows_processed / executions > 10000

         order by 4 desc) a

 where a.sql_id in (select sql_id

                      from v$sql_plan

                     where operation like '% NESTED LOOPS%'

                       and id <= 5);