Session Monitoring

Click [Realtime] > [Main Monitoring] > [Session Monitoring] in the global navigation bar to open the Session Monitoring page.

The Session Monitoring page displays session information directly retrieved from the monitored DB via the collection agent, showing real-time metrics such as logical reads, physical reads, execute counts, and hard parses for each currently connected session.

Filtering functionality is provided by column (e.g., SID, user name, program), and users can monitor detailed information for each session by linking to the session details view. Users granted the [Kill Session] permission for the selected instance in Configurable Privileges can terminate sessions for that instance.

Key Features of Session Monitoring

Session List

Displays session information for each session in the monitored database in a table format, with the last update time specified to indicate the current time of the information.

Item	Description
SID	Session ID
Serial#	Serial number of the session
Elapsed Time	Elapsed time of the SQL currently being executed in the session
Username	Current user name
Program	The name of the program in the session
Module	The name of the module specified by dbms_application_info.set_module
Logical Reads	The Logical Reads value of the session
Physical Reads	The Physical Reads value of the session
Execute Count	Execute Count value for the session
Hard Parse Count	Hard Parse value for the session
Wait Event	Wait Event name for the session
Wait Time	The time the session waited for the Wait Event
Status	The status of the session READY: Session ready status RUNNING: Session running status TX_RECOVERING: Transaction recovery in progress status SESS_CLEANUP: Session resource cleanup in progress state ASSIGNED: Session thread assigned but not yet ready state CLOSING: Session closed state ROLLING_BACK: PE specification level transaction slave rolled back state
State	Work thread status INVALID: Not initialized NEW: Being created IDLE: Ready to run RUNNING: Running WAITING: Waiting for internal message RECV_WAITING: Waiting for client message STOP_BY_MTHR: Stopped by monitoring process DEAD: Dead state
PGA Used Memory	Session's PGA memory usage
SQL Trace	Whether to enable SQL tracing in the session
WLock Wait	Wait type that the session is waiting for
Redo Entries	Redo Entries value of the session
Tx Undo Block Count	Number of transaction undo blocks
Tx Undo Record Count	Number of transaction undo records
User Commits	Session User Commits value
Audsid	Second serial number of the session
User ID	User ID information
IP Address	User connection IP address
Command	Current SQL Type 0: No SQL running 1: SELECT 2: INSERT 3: UPDATE 4: DELETE 5: MERGE 6: CALL
Schema	Session Schema
Session Type	Session type WTHR: Working thread CTHR: Control thread LGWR: Log writing process CKPT: Checkpoint process LARC: Log archive AGENT: Sequence process MTHR: Monitoring process DBWR: Datablock writing process LNW: Log network writing process
SQL ID	SQL ID of the SQL being executed by the session
Previous SQL ID	SQL ID of the last SQL executed
Child Number	Child Number value of the SQL ID being executed by the session
Previous Child Number	Child Number value of the last executed SQL ID
Logon Time	The logon time of the session
Client PID	Client PID of the session
PID	The identifier of the process to which the session belongs
OS User	OS account name of the connected session
Machine	Host name of the connected session
Terminal	Terminal (TTY) information for the connected session
Action	Name of the action specified by dbms_application_info.set_module/action
Client Info	The name of the client_info specified by dbms_application_info.set_client_info
Client Identifier	The name of the client ID specified by dbms_session.set_identifier

Note

Due to an issue with the Tibero library used for collecting session information, some information such as Username, Program, Module, Schema, Terminal, Machine, and OS User may not be collected.

Long-running session monitoring

Users can set the Elapsed Time threshold, and sessions that have been running for longer than the specified duration can be visually identified by color.

Kill Session

The users can terminate a session. This action is only available to users with Full privileges for the Session Monitoring feature, and the button will only appear when a specific session is selected in the session list.

Note

The users can terminate the sessions of the instance (Session Kill). This feature is available only to users who have been granted the [Kill Session] permission for the selected instance in the Configurable Privileges.

Clicking the [Kill Session] button opens the Kill Session pop-up window, where the users can either kill the session or cancel the action.

The following is a description of the information provided in the Kill Session pop-up window.

Item	Description
SID / Serial#	Session ID / Session serial number
Status	Session status
User Name	Session user name
Program	Session program name
Module	Session module name
Wlock Wait	Wait type the session is waiting for
Machine	Host name of the connected session