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:
|
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 MiB Mebibyte = 1.048.576 Bytes (cluster wide) |
PERSISTENT_DB_RAM
|
Current modified, persistent database memory usage in MiB 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 |