【TUNE_ORACLE】列出带有自定义函数的SQL的SQL参考

实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考

select distinct sql_id, sql_text, module

  from v$sql,

       (select object_name

          from dba_objects o

         where owner = 'TEST'

           and object_type in ('FUNCTION', 'PACKAGE'))

 where (instr(upper(sql_text), object_name) > 0)

   and plsql_exec_time > 0

   and REGEXP_LIKE(upper(sql_fulltext), '^[SELECT]')

   and parsing_schema_name = 'TEST';