The query corresponding to each monitoring element to check the session status is as follows. To monitor only information about a specific session, add the 'id' column of v$session to the WHERE clause.
[SS01] Total Number of Sessions
This shows the number of sessions connected to the Altibase server.
[SS02] Session Information
- The user can view session related information such as session client information and login time.
The following query can be used in Altibase version 5 or later, but can also be used in Altibase version 4 by deleting or commenting the CLIENT_APP_INFO column.
Main Column Description
|CLIENT_IP||The ip address of the client application associated with the session|
|CLIENT_PID||The process ID of the client application related to the session can identify the related process in the OS in which the client application runs.|
|CLIENT_APP_INFO||The name of the client application associated with the session||Column added starting from Altibase v5|
|SESSION_STATE||As a string representing the state of the session, there are 7 states: INIT, AUTH, SERVICE READY, SERVICE, END, ROLLBACK, and UNKNOWN|
|IDLE_TIME||The time at which the session started doing nothing, which is the basis for idle_timeout. The unit is Unix time.|
|CURRENT_QUERY||The query that was last performed or currently running in the session|
[SS03] Session Information Connected With SYSDBA Authority
- The user can check the information of the connected session with SYSDBA authority.
- The following query can be used starting from Altibase v5, but it can also be used in the Altibase v4 by deleting or commenting on the CLIENT_APP_INFO column.
The column used in the SELECT clause is the same as Session Information, so refer to the column description of the query.