Chat now with support
Chat mit Support

Spotlight on Oracle 10.5 - Release Notes

Sessions Page

Shows user sessions where parsing may be a problem.

To open the Sessions page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. 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:

  1. Right-click the session and select Session Details. Spotlight opens the Top Sessions Page with the session selected.
  2. 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

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.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen