Column | TDV JDBC Data Type | 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. | |