eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_XS_ACTIVE_SESSIONS

Object Details

Object Name:	DBA_XS_ACTIVE_SESSIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All the attached application sessions in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USER_NAME	VARCHAR2	(128)	Yes	User name of the application session
SESSIONID	RAW	(16)	Yes	Application session ID
DATABASE_SESSIONID	NUMBER			ID of the database sesssion that the application session is attached to
PROXY_USER	VARCHAR2	(128)		Name of the proxy user
COOKIE	VARCHAR2	(1024)		Cookie associated with the application session
CREATE_TIME	TIMESTAMP(6)	(11)	Yes	Creation time of the application session
AUTH_TIME	TIMESTAMP(6)	(11)	Yes	The most recent authentication time of the application session
ACCESS_TIME	TIMESTAMP(6)	(11)	Yes	The most recent access time of the application session
INACTIVE_TIMEOUT	NUMBER	(6)		Application session inactivity timeout

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_NAME
,      SESSIONID
,      DATABASE_SESSIONID
,      PROXY_USER
,      COOKIE
,      CREATE_TIME
,      AUTH_TIME
,      ACCESS_TIME
,      INACTIVE_TIMEOUT
FROM SYS.DBA_XS_ACTIVE_SESSIONS;

Dependencies

[top of page]

SYS.DBA_XS_ACTIVE_SESSIONS references the following:

SYS: RXS$SESSIONS; XS$OBJ

SYS.DBA_XS_ACTIVE_SESSIONS is referenced by following:

PUBLIC: DBA_XS_ACTIVE_SESSIONS