PL/SQL (MOSC)

MOSC Banner

DBMS_HPROF with pipelined function?

edited May 6, 2013 10:57PM in PL/SQL (MOSC) 22 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center