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