Firebird monitor active user

select
MON$ATTACHMENT_ID      ATTACHMENT_ID,
MON$SERVER_PID         SERVER_PID,
MON$STATE              STATE,
MON$ATTACHMENT_NAME    ATTACHMENT_NAME,
MON$USER               DB_USER,
MON$ROLE               DB_ROLE,
MON$REMOTE_PROTOCOL    REMOTE_PROTOCOL,
MON$REMOTE_ADDRESS     REMOTE_ADDRESS,
MON$REMOTE_PID         REMOTE_PID,
MON$CHARACTER_SET_ID   CHARACTER_SET_ID,
MON$TIMESTAMP          LOGIN_TIMESTAMP,
MON$GARBAGE_COLLECTION GARBAGE_COLLECTION,
MON$REMOTE_PROCESS     REMOTE_PROCESS,
MON$STAT_ID            STAT_ID
from
MON$ATTACHMENTS

Comments