【TUNE_ORACLE】列出走了Filter的SQL参考

实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考select parsing_schema_name schema, sql_id, sql_text  from v$sql where parsing_schema_name = 'TEST'   and (sql_id, child_number) in       (select sql_id, child_number          from v$sql_plan         where operation = 'FILTER'           and filter_predicates like '%IS NOT NULL%'        minus        select sql_id, child_number          from v$sql_plan         where object_owner = 'SYS');