Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

    Code Block
    languagesql
    SELECT A.ID SESSION_ID
         , A.DB_USERNAME USER_NAME
         , REPLACE2(REPLACE2(A.COMM_NAME, 'SOCKET-', NULL), '-SERVER', NULL) CLIENT_IP
         , A.CLIENT_APP_INFO              -- Delete it if using Altibase v4
         , A.CLIENT_PID
         , A.SESSION_STATE
         , DECODE(A.AUTOCOMMIT_FLAG, 1, 'ON', 'OFF') AUTOCOMMIT
         , DECODE(A.LOGIN_TIME, 0, '-', TO_CHAR(TO_DATE('1970010109', 'YYYYMMDDHH') + A.LOGIN_TIME / (24*60*60), 'MM/DD HH:MI:SS')) LOGIN_TIME
         , DECODE(A.IDLE_START_TIME, 0, '-', TO_CHAR(TO_DATE('1970010109', 'YYYYMMDDHH') +A.IDLE_START_TIME / (24*60*60), 'MM/DD HH:MI:SS')) IDLE_TIME
         , NVL(LTRIM(B.QUERY), 'NONE') CURRENT_QUERY
      FROM V$SESSION A LEFT OUTER JOIN V$STATEMENT B ON A.CURRENT_STMT_ID = B.ID
     WHERE A.SYSDBA_FLAG = 1 ;

...