Sessions Page
Shows user sessions where parsing may be a problem.
To open the Sessions page
-
Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click SQL & Application Workload | Parse Activity Page | Sessions.
Top Sessions by Hard Parse Time Grid
If you identify a particular session that is causing the problem, you can kill it:
- Right-click the session and select Session Details. Spotlight opens the Top Sessions Page with the session selected.
- Right click the session on the Top Sessions page and select Kill/Disconnect Session. See the documentation for Top Sessions Page for more information.
| Column | Description |
|---|---|
| Instance name | The instance in the Oracle RAC cluster where the session is connected. |
|
SID |
Session ID of the connected session. |
|
Oracle User |
The user running the session. |
|
Program |
The program running in the session. |
|
Module |
The active module within the program. |
|
Hard Parse Time (s) |
The total time spent hard-parsing SQL statements submitted for execution in the session. |
|
Hard Parse Ratio |
The ratio of time spent hard-parsing in the session as a percentage of DB time for the session (time spent processing user calls). |
|
Failed Parse Time (s) |
The amount of time spent unsuccessfully parsing SQL statements submitted in the session that contain an error (such as a syntax error, for example). |
|
Failed Parse Ratio |
The ratio of time spent in failed parsing in the session as a percentage of DB time for the session. |
|
Total Parse Time (s) |
The total time spent parsing SQL statements submitted for execution in the session. |
|
Total Parse Ratio |
The total time spent parsing SQL statements submitted for execution in the session as a percentage of the active database time spent in the session. |
|
Machine |
The machine where the session originated. |
|
OS User |
The O/S user that initiated the session. |
Note: The metrics in the Top Sessions by Hard Parse Time table are derived from data collected from V$SESS_TIME_MODEL.