V$XS_SESSION

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 REAUTH_SESSION PL/SQL procedure or the reauthenticateSession Java method to change this value.

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)   ???