Home » SQL & PL/SQL » SQL & PL/SQL » How to get profiler report (oracle 10 g)
How to get profiler report [message #421821] Thu, 10 September 2009 18:12 Go to next message
bond007
Messages: 58
Registered: March 2009
Member
Hi Friends,
How can I get How to get profiler report. I did the following steps.
Declare
b BINARY_INTEGER;
Begin
b:=DBMS_PROFILER.start_profiler(run_comment=>'Message ');
sort_proc;
b:=DBMS_PROFILER.stop_profiler;
end;
/

[Updated on: Thu, 10 September 2009 19:10]

Report message to a moderator

Re: How to get profiler report [message #421831 is a reply to message #421821] Thu, 10 September 2009 23:10 Go to previous messageGo to next message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query plsql_profiler_% tables.

Regards
Michel
Re: How to get profiler report [message #421834 is a reply to message #421821] Thu, 10 September 2009 23:34 Go to previous messageGo to next message
bond007
Messages: 58
Registered: March 2009
Member
Query plsql_profiler_% tables.



sorry michale I didnt get that . Should I have to create plsql_profilertable ?
Re: How to get profiler report [message #421836 is a reply to message #421834] Thu, 10 September 2009 23:39 Go to previous message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, using the script provided by Oracle, please read the documentation.

Regards
Michel
Previous Topic: DDL trigger wont fire on ALTER TABLE EXCHANGE PARTITION
Next Topic: SPOOL IN PL/SQL BLOCK
Goto Forum:
  


Current Time: Fri Sep 30 17:29:36 CDT 2016

Total time taken to generate the page: 0.20063 seconds