|DBMS_PROFILER - Profile the run-time behaviour of PL/SQL code to identify potential bottlenecks.|
Subash said...Good Job Tim, you have conveyed how to use it. The reader can then take off and use the respective functions and variants.
tibbu said...i did exactly as you said but for me when i run the procedure to start and stop profiler, it says
identifier 'do_something' must be declared.
what to do ?
"do_something" is the name of the procedure I create in the article. It is the procedure I'm tracing. If you want to practice the tracing, you must create this procedure also.
If you are tracing your own code, then don;t call "do_something", call your own code instead.
TIBBU said...hi Tim, i i created procedure in other schema. that is why i was getting error. now i created proc in the same schema where iam running the profiler.
it runs now. but it didnot insert any records in the profiler tables.
why is that?
and also in my TOAD, profiler is disabled.
what should i do to enable it??
i have grant on the pkg dbms_profiler also
my TOAD version is 9.6.1
You should do the profiling and query the tables from the user that owns the procedure.
Please ask technical questions in the forums, not here.