Enabling TOAD s PLSQL Profiler Support

Enabling TOAD's PL/SQL Profiler Support

TOAD has a very capable PL/SQL profiler for detailed analysis of code execution behavior. But many people seem to have problems initially getting this feature to work. At first, the menu item and toolbar icon may not appear as enabled. That's because there are some TOAD schema objects that must be created. People next encounter issues on the profiler screen, because unknown to them there are Oracle profiler packages that must be created by the DBA in the SYS account (and which Oracle does not create by default). But in reality the steps to set up TOAD's profiler are quite easy:

1. Connect as SYS.

2. Run Oracle's RDBMS/ADMIN/PROFLOAD.SQL .

3. Connect as TOAD.

4. Run TOAD's TEMPS/TOADPROFILER.SQL .

If you don't create and use a TOAD schema, it would still be possible to enable TOAD profiler support in one of two ways:

• Run TOAD's TEMPS/TOADPROFILER.SQL as SYSTEM or other DBA account, because it creates public synonyms and grants object privileges to public.

• Run TOAD's TEMPS/TOADPROFILER.SQL as each and every TOAD user (just remember to comment out the public grants and synonyms portions near the bottom of the script).