DBMS_HPROF with pipelined function?
I'm new to DBMS_HPROF and am trying to profile a pipelined function. However, once analyzed, neither the package function nor any of the subprogram called within the same package display in SQLDeveloper or TOAD, the only procedure that displays is a call to a different packages function.
Here's basically what I'm doing in sqlplus:
exec dbms_hprof.start_profiling ('ORACLE_DIR','test_0208.txt')
select *
from table(pkg_sdc_intg.user_aggr_usage('KJ-TEST'));
exec dbms_hprof.stop_profiling;
variable hprof_run number
exec :hprof_run := dbms_hprof.analyze('ORACLE_DIR','test_0208.txt')
print :hprof_run
I can query and see the data in the dbmshp* tables.
0