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]

TABLE: SYS.RXS$SESSIONS

Object Details

Object Name:	RXS$SESSIONS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_RXS$SESSIONS1	NORMAL	UNIQUE	SYSTEM	COOKIE
RXS$SESSIONS_I1	NORMAL	UNIQUE	SYSTEM	SID

Columns

Name	Datatype	Length	Mandatory
USERNAME	VARCHAR2	(128)	Yes
USERID	NUMBER	(10)	Yes
USERGUID	RAW	(16)
ACLOID	RAW	(16)
SID	RAW	(16)	Yes
COOKIE	VARCHAR2	(1024)
PROXYGUID	RAW	(16)
CREATORID	NUMBER	(10)	Yes
UPDATORID	NUMBER	(10)	Yes
CREATETIME	TIMESTAMP(6)	(11)	Yes
AUTHTIME	TIMESTAMP(6)	(11)	Yes
ACCESSTIME	TIMESTAMP(6)	(11)	Yes
INACTIVETIMEOUT	NUMBER	(6)
SESSIZE	NUMBER
FLAG	NUMBER
PROXYID	NUMBER	(10)
EFFSTARTDATE	TIMESTAMP(6)	(11)
EFFENDDATE	TIMESTAMP(6)	(11)
RGVERSION	NUMBER	(10)
ATTACHVERSION	NUMBER	(10)
WSPACE	VARCHAR2	(128)
SCVERSION	NUMBER	(10)
SCINSID	NUMBER

Query Text

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


SELECT USERNAME
,      USERID
,      USERGUID
,      ACLOID
,      SID
,      COOKIE
,      PROXYGUID
,      CREATORID
,      UPDATORID
,      CREATETIME
,      AUTHTIME
,      ACCESSTIME
,      INACTIVETIMEOUT
,      SESSIZE
,      FLAG
,      PROXYID
,      EFFSTARTDATE
,      EFFENDDATE
,      RGVERSION
,      ATTACHVERSION
,      WSPACE
,      SCVERSION
,      SCINSID
FROM SYS.RXS$SESSIONS;

Dependencies

[top of page]

SYS.RXS$SESSIONS does not reference any database object

SYS.RXS$SESSIONS is referenced by following:

SYS: DBA_XS_ACTIVE_SESSIONS; DBA_XS_SESSIONS; DBMS_FEATURE_RAS - show dependent code; USER_XS_PASSWORD_LIMITS