SYS_SESSIONS
The SYS_SESSIONS system table provides a list of current and recent sessions and their current status.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see rows for all sessions they own. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights see all rows.
|
Column |
TDV |
Nullable |
Description |
|
SESSION_ID |
BIGINT |
|
Unique session ID. |
|
OWNER_ID |
INTEGER |
|
The ID of the user logged into this session. |
|
OWNER |
VARCHAR(255) |
|
The name of the user logged into this session. |
|
SESSION_TYPE |
VARCHAR(20) |
|
The session type can be one of the following: HTTP—A web services client. INTERNAL—A session started within the server. JDBC—A JDBC client. ODBC—An ODBC client. STUDIO—The Studio tool. |
|
SESSION_NAME |
VARCHAR(255) |
Yes |
The name of the session. NULL if not provided by the client. |
|
HOST |
VARCHAR(255) |
Yes |
The host the client is connecting from. NULL for INTERNAL sessions. |
|
DATASOURCE_ID |
INTEGER |
Yes |
The data service ID the client is connecting on. NULL if no data service is in use. |
|
LOGIN_TIME |
TIMESTAMP |
|
The time at which the session started. |
|
LOGOUT_TIME |
TIMESTAMP |
Yes |
The time at which the session ended. NULL if the session is still active. |
|
STATUS |
VARCHAR(20) |
|
The session status can be one of the following: ACTIVE—The session is still active. CLOSED—The session was closed in an orderly fashion. DISCONNECTED—The session was disconnected. TERMINATED—The session was terminated. TIMED_OUT—The session timed out. |
|
IDLE_DURATION |
BIGINT |
|
The number of milliseconds the session has been idle. |
|
TIMEOUT_DURATION |
BIGINT |
|
The number of milliseconds after which the session will time out. |
|
TOTAL_REQUESTS |
INTEGER |
|
The number of requests created on this session. |
|
ACTIVE_REQUESTS |
INTEGER |
|
The number of requests open on this session. |
|
TOTAL_TRANSACTIONS |
INTEGER |
|
The number of transactions created on this session. |
|
ACTIVE_TRANSACTIONS |
INTEGER |
|
The number of transactions open on this session. |
|
BYTES_TO_CLIENT |
BIGINT |
|
The estimated number of bytes sent to the client. |
|
BYTES_FROM_CLIENT |
BIGINT |
|
The estimated number of bytes received from the client. |