Home » SQL & PL/SQL » Client Tools » about profiler
about profiler [message #343909] Thu, 28 August 2008 07:42 Go to next message
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
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.


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

Login to Oracle through Toad as SYS.

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

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

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.

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

Current Time: Sun Jan 17 02:39:27 CST 2021