You must also have the DBMS_HPROF package to use the hierarchical profiler, which is available in Oracle 11g and later. Select View | Toad Options | Execute/Compile and then select Use hierarchical profiler on Oracle 11g and newer.
To use the hierarchical profiler, you must enable it in the Toad options. Make sure that GRANT EXECUTE on the DBMS_PROFILER package has been granted to PUBLIC or to the users that will use the profiling feature.Īdditional Hierarchical Profiler Requirements.Load the Oracle home>\RDBMS\ADMIN\PROFLOAD.SQL script into the Editor.Login to an Oracle database through Toad as SYS.You must have the SYS.DBMS_PROFILER package to use the DBMS profiler. Note: To remove the profiler objects, click the arrow by and select Remove Profiler. You can use the DBMS Profiler with Oracle 8i and later, or the hierarchical profiler with Oracle 11g and later. If they do not already exist, Toad prompts you to create them when you click. This feature requires that certain objects exist on the server before you can use it.
0 kommentar(er)
