| about profiler [message #343909] |
Thu, 28 August 2008 07:42  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
