实验环境

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