In the Database menu both the PL/SQL profiling and Profiler Analysis are grayed out.
Prerequisites to use PL/SQL Profiler in TOAD:
1) The DBMS_PROFILER package needs to be installed. This can be installed by running the profload.sql script which can be found in your
%ORACLE_HOME%/Rdbms/Admin directory. This script must be executed as the SYS schema.
package sys.dbms_profiler
public synonym dbms_profiler
library sys.dbms_profiler_lib
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.
2) The profiler server side objects for TOAD will have to be installed and can be done from Tools | Server Side Objects Wizard in Toad for Oracle 10 and older. In Toad for Oracle 11 and newer, the Server Side Object Wizard has been removed. Each feature with server-side objects now directly provides a way to install the required objects.
Server side objects need to be set up for each database you wish to run profiler on.
Once the above has been completed restart TOAD for the changes to take effect.
If the Server Side Objects are already installed and they are still grayed out, make sure your Oracle client does not have two entries listed in the Environment Variable Path. You can check this by...
1) Right click on My Computer and select Properties.
2) In the Advanced tab, click the Environment Variables button.
3) In the bottom portion of the window, highlight the PATH variable and click Edit.
4) View the string and make sure your client's path is not listed more than once in there. It may be easier to view if you copy and paste it in notepad.
5) If it is listed multiple times, delete one of them.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center