EXA_DBA_SESSIONS
This system table contains complete information on open sessions of any database user. It also shows the
most recent SQL statement.
Only users with the SELECT ANY DICTIONARY
system privilege have access to the table.
Column Name | Description |
---|---|
SESSION_ID
|
Id of the session |
USER_NAME
|
Name of the logged-in user |
EFFECTIVE_USER
|
Effective user of the session (changeable via IMPERSONATE) |
STATUS
|
Current status of the session. The most important of these are:
|
COMMAND_NAME
|
Name of the statement (for example, SELECT , COMMIT , MERGE ) |
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 |
HOST
|
Computer name or IP address from which the user has logged-in |
OS_USER
|
User name under which the user logged into the operating system of the computer from which the login came |
OS_NAME
|
Operating system of the client |
SCOPE_SCHEMA
|
Schema that was explicitly opened by means of a connection parameter or OPEN SCHEMA command |
CONSUMER_GROUP
|
Current consumer group |
NICE
|
NICE attribute |
RESOURCES
|
Allocated resources in percent |
SQL_TEXT
|
SQL text of the statement |