SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_PROFILER and ONLY ANONYMOUS

ZaboMay 21 2013 — edited May 24 2013

Hello,

I'm using 11gR2.

I followed this tutorial (http://www.oracle-base.com/articles/9i/dbms_profiler.php) to install and test dbms_profiler.

I'm surprised to get only information about ANONYMOUS BLOCK, although I should see information about DO_SOMETHING.

Can anyone give me help ?

Thanks.

SQL> select * from PLSQL_PROFILER_UNITS;

RUNID UNIT_NUMBER UNIT_TYPE
---------- ----------- --------------------------------
UNIT_OWNER UNIT_NAME UNIT_TIM
-------------------------------- -------------------------------- --------
TOTAL_TIME SPARE1 SPARE2
---------- ---------- ----------
1 1 ANONYMOUS BLOCK
<anonymous> <anonymous> 00/00/00
0

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2013

Added on May 21 2013

11 comments

626 views