Home » SQL & PL/SQL » Client Tools » about profiler
about profiler [message #343909] Thu, 28 August 2008 07:42 Go to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
how to enable and use profiler provided with toad version 9
Re: about profiler [message #344067 is a reply to message #343909] Thu, 28 August 2008 12:56 Go to previous message
tyler_durden
Messages: 14
Registered: August 2008
Location: http://tinyurl.com/63fmwx
Junior Member
This is a basic documentation question, so here's the answer from the documentation:

Setting Up the Profiler
-----------------------
You can set up the profiler to run from the Toad schema, or any private user’s schema. Each case has a different script to run, as explained in the steps below.

Note: The minimum Oracle database version required for the PL/SQL Profiler is Oracle8i.

The SYS.DBMS_PROFILER package

Make sure you have the SYS.DBMS_PROFILER package. If this has not been loaded, you will need to create it as follows.

1.
Login to Oracle through Toad as SYS.

2.
Load the Oracle home>\RDBMS\ADMIN\PROFLOAD.SQL script into the Editor.

3.
From the SQL Editor menu, select Execute as Script (or press F5).

4.
Make sure that GRANT EXECUTE on the DBMS_PROFILE package has been granted to PUBLIC or to the users that will use the profiling feature.

Install Profiler Server Side Objects
------------------------------------
To install the server side objects required for the profiler, run the Server Side Objects Install wizard.


tyler_durden
Previous Topic: Storing Chinese characters
Next Topic: ORA-00600; internal error code (merged)
Goto Forum:
  


Current Time: Thu Dec 08 06:02:04 CST 2016

Total time taken to generate the page: 0.07716 seconds