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.
Altibase 5 or later
Column Name | Description | Remarks |
---|---|---|
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 [SS02] Session Information, so refer to the column description of the query.