EXA_ALL_SESSIONS

This system table contains restricted information on open sessions of any database user. Among other things, the most recent SQL statement is shown. For security reasons, only the command name is displayed. All users have access to this table.

The complete SQL text is available in EXA_USER_SESSIONS and EXA_DBA_SESSIONS.

Column Name Description
SESSION_ID Id of the session
USER_NAME Logged-in user
STATUS

Current status of the session. The most important of these are:

  • IDLE: Client is connected but not taking any action.
  • EXECUTE SQL: Execution of one single SQL statement.
  • EXECUTE BATCH: Execution of a series of SQL statements.
  • PREPARE SQL: Entry of a prepared statement.
  • EXECUTE PREPARED: Execution of a prepared statement.
  • FETCH DATA: Client reads results.
  • QUEUED: Client is queued because too many parallel queries are executed.
  • COMMIT STMT TIMEOUT: Commit aborted due to query timeout.
  • STMT TIMEOUT: Statement aborted due to query timeout.
COMMAND_NAME Name of the statement (for example. SELECT, COMMIT, MERGE etc.)
STMT_ID Serially numbered id of statement within a session
DURATION Duration of the current statement in seconds
QUERY_TIMEOUT Session-specific value of QUERY_TIMEOUT, see also ALTER SESSION and ALTER SYSTEM
ACTIVITY Current activity of the SQL
TEMP_DB_RAM Current temporary database memory usage in MiBClosed Mebibyte = 1.048.576 Bytes (cluster wide)
PERSISTENT_DB_RAM Current modified, persistent database memory usage in MiBClosed Mebibyte = 1.048.576 Bytes (cluster wide)
LOGIN_TIME Time of login
CLIENT Client application used by the user
DRIVER Used driver
ENCRYPTED Flag whether the connection is encrypted
CONSUMER_GROUP Current consumer group
NICE NICE attribute
RESOURCES Allocated resources in percent
CLUSTER_NAME Name of the cluster on which the session is currently running