Using PL/SQL Profiler

From RapidSQL
Jump to: navigation, search

Go Up to PL/SQL Profiler

The steps in this section provide a high level overview of running a profiling session, and cover the following processes:

  • Starting the Session.
  • Executing the Sample Script.
  • Stopping and Analyzing the Session.
Note: The first execution of a PL/SQL unit can take more time to execute because the code is loading into memory; subsequent runs take less time.

Using the PL/SQL Profiler


1. If using Rapid SQL, on the Tools menu, select SQL Profiler > Start.
The PL/SQL Profiler - Start dialog opens.
2. In the Profile Label box, type the name of the new profile.
Note: Each user can own one or more Profiles.
3. Click OK.
Profiling begins.
4. On the Datasource Navigator, execute on one of the following PL/SQL database objects:
  • Procedure
  • Function
  • Package Procedure
  • Package Function
Profiler displays profiling data in the right pane of the application.
5. If using Rapid SQL, on the Tools menu, select SQL Profiler > Stop.
The PL/SQL Profiler - Stop dialog opens.

The table below describes the options and functionality on the PL/SQL Profiler - Stop dialog:

Option Description

Stop

Click to stop the profiling session.

Stop & Analyze

Click to open the PL/SQL Profiler Run Detail window. For details, see Run Detail. Click the Label list, and then click the target profile. Click the Run list, and then click the target run. Click the Unit Type list, and then click the target unit type(s). Click the Unit Owner list, and then click the target unit owner(s) to populate the table.

Cancel

Click to continue the profiling session.


6. If using Rapid SQL, use the Tools menu to open any of the following PL/SQL Profiler windows. For more information, see:

Topics