Session monitoring

Note

The users can pull down multiple databases and instances to monitor at the same time.

1. Navigate to the OwlDB console screen > Monitoring > Session Monitoring menu.

2. Click the DB Alias, Instance Alias drop-down buttons to pull down the databases and instances the users want to monitor.

3. Check the list of sessions.

Tibero

Item	Description
SID	Session ID
SERIAL#	Session Serial Number
AUDSID	Secondary Serial Number of the session
USER#	Current User ID
USERNAME	Current User Name
IPADDR	IP Address from which the current User is connected
COMMAND	Type of SQL currently being performed - 1: SELECT - 2: INSERT - 3: UPDATE - 4: DELETE - 5: MERGE - 6: CALL
STATUS	Session Status - READY : Session is ready - RUNNING : Session is running - TX_RECOVERING : Recovering transaction - SESS_CLEANUP : Cleaning session resources - ASSIGNED : Thread assigned to the session but not ready - CLOSING : Closing the session - ROLLING_BACK : Statement level transaction of PE slave is rolled back
SCHEMA#	Current schema ID
SCHEMANAME	Current schema name
TYPE	Session Type - WTHR : Working thread - CTHR : Control thread - LGWR : Log writing process - CKPT: Checkpoint process - LARC: Log archive - AGENT: Sequence process - MTHR: Monitoring processMonitoring process - DBWR: Data block writing process - LNW : Log network writing process
SQL_ID	SQL identifier of the currently executing SQL statement
SQL_CHILD_NUMBER	Child number of the currently executing SQL statement
PREV_SQL_ID	ID of the most recently executed SQL statement
PREV_CHILD_NUMBER	Child number of the most recently executed SQL statement
SQL_ET	Time elapsed since the SQL statement was executed (in seconds)
LOGON_TIME	When the session was created
STATE	Waiting status of the thread - INVALID: Not initialized - NEW: Created - IDLE: Ready to run - RUNNING: Running - WAITING: Waiting for internal messages - RECV_WAITING: Waiting for client messages - STOP_BY_MTHR: Stopped by MTHR - DEAD: Dead
WLOCK_WAIT	Type of lock the session is waiting for WAIT
WAIT_EVENT	Type of event the session is waiting for WAIT
WAIT_TIME	Wait time for the wait_event the session is waiting for
PGA_USED_MEM	Amount of PGA memory occupied by the session
SQL_TRACE	SQL Trace of the session. Performed or not
PROG_NAME	Client Program name
CLIENT_PID	Identifier of the client's Process
PID	Identifier of the Process to which the session belongs
WTHR_ID	Index of the worker thread to which the session belongs
OS_THR_ID	Identifier of the thread created by the OS to which the session belongs identifier
OSUSER	Name of the OS account of the connected
MACHINE	Name of the host of the connected session
TERMINAL	Terminal (tty) information of the connected session
MODULE	Name of the module set by the user in the program run by the client
ACTION	Name of the action set by the user in the module that is currently being performed
CLIENT_INFO	Client information set by the user
CLIENT_IDENTIFIER	Client identifier set by the user
PDML_ENABLED	Parallel dml activation mode - Yes / No
PDML_STATUS	Parallel dml status - FORCE : Changed to forced enabled state - ENABLED : Activated state - DISABLED : Disabled state
PDDL_STATUS	Parallel ddl status - FORCE - ENABLED - DISABLED
PQ_STATUS	Parallel query status - FORCE - ENABLED - DISABLED
ROW_WAIT_OBJ_ID	IDROW_WAIT_ROW# the object of the table containing the specified row ID
ROW_WAIT_FILE_NO	ROW_WAIT_ROW# the identifier of the data file containing the specified row
ROW_WAIT_BLOCK_NO	ROW_WAIT_ROW# the identifier of the block containing the specified row The identifier of the block that contains the specified row
ROW_WAIT_ROW_NO	The row that is currently locked
CONSUMER_GROUP	The name of the Consumer group to which the current session belongs
CONSUMED_CPU_TIME	The cumulative CPU time used by the session

Note

The LOGON_TIME entry displays the time relative to the database timezone. It may differ from the user's local system time (browser time).

Tmax OpenSQL (On-Premise)

Note

Tmax OpenSQL is currently only supported in On-Premise environments.

Item	Description
#	Number in Row
PID	Identifier of the process
IP ADDR	IP address of the connected client
LOGON TIME	The time the session started
CLIENT HOSTNAME	The hostname to which the session is connected
PREV SQL ID*	ID of the last SQL that was conducted
PROGRAM NAME	Name of the client program
SCHEMA NAME	Name of the schema currently in use
SCHEMA NUMBER	ID of the currently used schema
SQL ELAPSED TIME	Elapsed time of the SQL currently being performed in the session.
SQL ID	ID of the currently executing SQL
STATUS	Status of the session
TYPE	The type of the session
USERNAME	The SQL-performing name of the session
USERID	The SQL-performing ID for this session
WAIT EVENT	The type of event the session is waiting for
LEADER PID	Process ID of the parallel group leader
CLIENT PORT	The port number of the client
XACT START	The time the current transaction of the process started
STATE CHANGE	The last time the state was changed
BACKEND XID	Transaction ID assigned when the query is started
BACKEND XMIN	Minimum value of the transaction ID associated with the current query
QUERY	Last SQL conducted (or the SQL currently being conducted if status is active)

Note

*PREV SQL ID, SQL ID can be expressed as a negative number; the users can look up its value in the pg_stat_statements view.

Caution

If the instance status is Down, Disconnect , some metrics might be missing.

---

Auto-refresh

For real-time updates of the monitoring screen, an automatic refresh function is supported. Click the ⚙️ icon in the upper left corner to set the refresh cycle.

---

Elapsed Time Notification

Provides a visual notification to the user by highlighting the row of the table when the threshold of time the users set is exceeded. The users can set the threshold by clicking⚙️icon.

Item	Description
Warning-	- Range: 0.1 to 1000.0 seconds - Indicated by red highlighting - Set to a time longer than the Caution level
Caution	- Range: 0.1 to 999.0 seconds - Indicated by orange highlighting - Set to a time shorter than the Warning level