V$XS_SESSION displays information about the state of the XS$SESSION and XS$GLOBAL_VAR namespaces for all lightweight user sessions in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
USERNAME |
VARCHAR2(4000) |
NOT NULL |
Name of the lightweight user associated with the lightweight user session |
USERID |
RAW(16) |
NOT NULL |
Global unique identifier of the lightweight user associated with the lightweight user session |
ACLOID |
RAW(16) |
UUID of the ACL on the lightweight user session | |
COOKIE |
VARCHAR2(1024) |
Server-unique cookie value associated with the session | |
PROXYID |
RAW(16) |
UUID of the previous XS user who, through the SWITCH_USER API, has proxied into the current lightweight user identity |
|
CREATORID |
RAW(16) |
NOT NULL |
UUID of the user that created the lightweight user session |
UPDATEID |
RAW(16) |
NOT NULL |
UUID of the user that last accessed the lightweight user session |
CREATETIME |
TIMESTAMP(6) |
NOT NULL |
Creation time for the lightweight user session |
LAST_AUTH |
TIMESTAMP(6) |
NOT NULL |
Last time the lightweight user was authenticated
Note: The application or middle-tier must call the |
LAST_ACCESS |
TIMESTAMP(6) |
NOT NULL |
Time when the lightweight user session was last accessed |
TIMEOUT |
NUMBER(6) |
Amount of time (in minutes) before the session is considered to have timed out | |
NLS_CALENDAR |
VARCHAR2(255) |
NLS_CALENDAR parameter corresponding to the lightweight user session |
|
NLS_COMP |
VARCHAR2(255) |
NLS_COMP parameter corresponding to the lightweight user session |
|
NLS_CURRENCY |
VARCHAR2(255) |
NLS_CURRENCY parameter corresponding to the lightweight user session |
|
NLS_DATE_FORMAT |
VARCHAR2(255) |
NLS_DATE_FORMAT parameter corresponding to the lightweight user session |
|
NLS_DATE_LANGUAGE |
VARCHAR2(255) |
NLS_DATE_LANGUAGE parameter corresponding to the lightweight user session |
|
NLS_ISO_CURRENCY |
VARCHAR2(255) |
NLS_ISO_CURRENCY parameter corresponding to the lightweight user session |
|
NLS_LANGUAGE |
VARCHAR2(255) |
NLS_LANGUAGE parameter corresponding to the lightweight user session |
|
NLS_LENGTH_SEMANTICS |
VARCHAR2(255) |
NLS_LENGTH_SEMANTICS parameter corresponding to the lightweight user session |
|
NLS_NCHAR_CONV_EXCP |
VARCHAR2(255) |
NLS_NCHAR_CONV_EXCP parameter corresponding to the lightweight user session |
|
NLS_NUMERIC_CHRS |
VARCHAR2(255) |
NLS_NUMERIC_CHARACTERS parameter corresponding to the lightweight user session |
|
NLS_SORT |
VARCHAR2(255) |
NLS_SORT parameter corresponding to the lightweight user session |
|
NLS_TERRITORY |
VARCHAR2(255) |
NLS_TERRITORY parameter corresponding to the lightweight user session |
|
NLS_TIMESTAMP_FMT |
VARCHAR2(255) |
NLS_TIMESTAMP_FORMAT parameter corresponding to the lightweight user session |
|
NLS_TIMESTAMP_TZ_FMT |
VARCHAR2(255) |
NLS_TIMESTAMP_TZ_FORMAT parameter corresponding to the lightweight user session |
|
NLS_DUAL_CURRENCY |
VARCHAR2(255) |
NLS_DUAL_CURRENCY parameter corresponding to the lightweight user session |
|
APPS_FEATURE |
VARCHAR2(255) |
??? |