DBA_XS_ACTIVE_SESSIONS
The DBA_XS_ACTIVE_SESSIONS dynamic data dictionary view displays all attached application sessions in the database. Only database administrators can select from this view.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
USER_NAME |
VARCHAR2(128) |
NOT NULL |
Application user name of the application session |
SESSIONID |
RAW(16) |
NOT NULL |
Application Session identifier |
DATABASE_SESSIONID |
NUMBER |
The database session ID to which the application session is associated. | |
PROXY_USER |
VARCHAR2(128) |
Name of the proxy application user | |
COOKIE |
VARCHAR2(1024) |
The server-unique cookie value associated with the session | |
CREATE_TIME |
TIMESTAMP(6) |
NOT NULL |
Creation time for the application session |
AUTH_TIME |
TIMESTAMP(6) |
NOT NULL |
Last time the application user was authenticated. |
ACCESS_TIME |
TIMESTAMP(6) |
NOT NULL |
Last time that the application session was accessed |
INACTIVE_TIMEOUT |
NUMBER(6) |
The amount of time (in minutes) before the application session is considered timed out |