Database Session Information

This page displays detailed information about the selected database session.

Navigation: Site Map > Forms Sessions (under Activity) > (B) Session Details

or  Site Map > Service Status (under Application Services) > (Services region) [Service] > (B) View Processes > [AUDSID value] for a process

Click Terminate to end the database session.

Summary

• Form or Service Name

• Username

• Responsibility

Instance Attributes

• Logon Time

• Serial #

• OS PID

• Status

• Session ID

• Oracle SPID

• User

• SQL Hash - If the value shown is a link, you can click on it to view a page showing the SQL statement that is currently executing, as well as an execution plan for the statement.  For more information on execution plans, see the Oracle9i Database Performance Tuning Guide and Reference.

Client Attributes

• OS User

• Machine

• Process

• Terminal

Application Attributes

• Module

• Module Hash

• Action

• Program

Session Wait Information

• Event

• Wait Time

• Timeouts

• Average Wait

• Total Wait

• Maximum Wait

Tracing Options

Set the trace options to the level desired.  Options available are:

• Normal Trace

• Trace with Waits

• Trace Off

• Trace with Binds

• Trace with Binds and Waits

Click Apply to apply any changes made to the Tracing Options.

Click View Trace to view the current trace information.