实验环境

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