...
- 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.
Code Block language sql 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 ;
...