SQL & PL/SQL

Hi All,

I would like to collect statistics for my stored procedures using the DBMS_PROFILER Package, but when I run the package using the below sample, I'm getting errors mentioned below. I read the Oracle documentation that you need to have few scripts loaded (PROFTAB.sql.) etc to run this.

Could someone, please give me the exact steps that are needed so I can use this package in my schema. Steps like with which user does the scripts need to be run, whether the scripts need to be run in my schema, or privileges etc., to be granted to the package and so on.

Thanks.

Below is the sample run and errors I'm receiving. I'm using Oracle 11g version.

Sample run:

BEGIN

   DBMS_PROFILER.start_profiler('test_profile');

   test;

   DBMS_PROFILER.stop_profiler;

END;

Error report -

ORA-06528: Error executing PL/SQL profiler

ORA-06512: at "SYS.DBMS_PROFILER", line 123

ORA-06512: at "SYS.DBMS_PROFILER", line 132

ORA-06512: at line 2

06528. 00000 -  "Error executing PL/SQL profiler"

*Cause:    An error occurred in during execution of a PL/SQL profiler

           procedure.