【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);