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