Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.10 - Release Notes

Sessions Page

Shows user sessions where parsing may be a problem.

To open the Sessions page

  1. Select the Spotlight on Oracle RAC 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
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.

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation