Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »



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 Session Information, so refer to the column description of the query.



 


  • No labels