实验环境

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

ITPub博客

【TUNE_ORACLE】列出返回行数较多的嵌套循环（NESTED LOOPS）SQL的SQL参考