Oracle Sessions

You can use this procedure to display Oracle sessions.

1. Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Activity.

   Alternatively, use transaction code ST04.

2. Choose Detailed analysis menu →Oraclesession.

This screen displays information about the Oracle shadow processes from the Oracle system tables V$Session, V$Process, V$Session_Wait and V$Sess_IO. 

The most important fields mean:

SID:              Oracle session ID

ORA proc:      Prozess ID (at operating system level) of the Oracle shadow process

Clnt proc: Prozess ID (at operating system level) of the R/3 work process

Client-Host:    Name of the host running the R/3 work process

Status:          'ACTIVE' or 'INACTIVE'

Event:      Event for which the process is waiting (only valid if the process is set to 'INACTIVE') 

The 'Wait events' screen displays statistics about the events.

You can use the Filter function to display only active sessions, or sessions that are not in the event'SQL*Net message from client'. 

You can display information - if available - on the R/3 work processes using the function R/3 WPs. 

See also:

Wait Events (Oracle)

Exclusive Lockwaits (Oracle)