Skip to end of metadata
Go to start of metadata



Session


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
  • Main Column Description

Column NameDescriptionRemarks
CLIENT_IPThe ip address of the client application associated with the session 
CLIENT_PIDThe 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_INFOThe name of the client application associated with the sessionColumn added starting from Altibase v5
SESSION_STATEAs a string representing the state of the session, there are 7 states: INIT, AUTH, SERVICE READY, SERVICE, END, ROLLBACK, and UNKNOWN 
IDLE_TIMEThe time at which the session started doing nothing, which is the basis for idle_timeout.  The unit is Unix time. 
CURRENT_QUERYThe 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.



 


  • No labels