Unit Detail
Go Up to PL/SQL Profiler Functionality
The PL/SQL Profiler Unit Detail window lets you to view the following information for each of your profiles:
- Average Time
- Source
- PL/SQL Script
The PL/SQL Profiler Unit Detail window lets you view results in milliseconds, seconds and minutes. The Unit Detail window also provides two calculation options for viewing unit execution time as a percentage of total execution time (total run vs unit run). Additionally, also displays graphs of execution statistics for the top N run. You can use the graphical displays to navigate to the specific line within source code portion of the window.The graphical display portion of the window contains options for viewing advanced statistics.
The Advanced View of the PL/SQL Profiler Unit Detail window lets you view the following information for each of your profiles:
- Hit Lines
- Missed Lines
- Line Number
- Calls
- Total Time
- Percentage of the Total Time
- Average Time
- Minimum Time
- Maximum Time
Opening the Unit Detail Window
To open the Unit Detail Window, do the following:
- Tthe PL/SQL Profiler - Unit Detail window opens.
- 2. In the PL/SQL Profiler - Unit Detail window, do any of the following:
- Click the Label list, and then click the target profile.
- Click the Run list, and then click the target run.
- Click the Unit list, and then click the target unit to populate the table.
- Right-click, and then click Show Only Hit Lines to populate the table with the Average Time and Source for hit lines.
- Right-click, and then click Show Only Missed Lines to populate the table with the Average Time and Source for missed lines.
Opening the Unit Detail Window Advanced View
To open the Unit Detail Window Advanced View, do the following:
- In the Unit Detail window, right-click, and then click Advanced View to populate the table with Advanced View information.