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_AUDIT_SESSION

Object Details

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

All audit trail records concerning CONNECT and DISCONNECT

[View Source]

Columns

Name	Datatype	Length	Mandatory
OS_USERNAME	VARCHAR2	(255)
USERNAME	VARCHAR2	(128)
USERHOST	VARCHAR2	(128)
TERMINAL	VARCHAR2	(255)
TIMESTAMP	DATE
ACTION_NAME	VARCHAR2	(28)
LOGOFF_TIME	DATE
LOGOFF_LREAD	NUMBER
LOGOFF_PREAD	NUMBER
LOGOFF_LWRITE	NUMBER
LOGOFF_DLOCK	VARCHAR2	(40)
SESSIONID	NUMBER		Yes
RETURNCODE	NUMBER		Yes
CLIENT_ID	VARCHAR2	(128)
SESSION_CPU	NUMBER
EXTENDED_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)
PROXY_SESSIONID	NUMBER
GLOBAL_UID	VARCHAR2	(32)
INSTANCE_NUMBER	NUMBER
OS_PROCESS	VARCHAR2	(16)

Query Text

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


SELECT OS_USERNAME
,      USERNAME
,      USERHOST
,      TERMINAL
,      TIMESTAMP
,      ACTION_NAME
,      LOGOFF_TIME
,      LOGOFF_LREAD
,      LOGOFF_PREAD
,      LOGOFF_LWRITE
,      LOGOFF_DLOCK
,      SESSIONID
,      RETURNCODE
,      CLIENT_ID
,      SESSION_CPU
,      EXTENDED_TIMESTAMP
,      PROXY_SESSIONID
,      GLOBAL_UID
,      INSTANCE_NUMBER
,      OS_PROCESS
FROM SYS.DBA_AUDIT_SESSION;

Dependencies

[top of page]

SYS.DBA_AUDIT_SESSION references the following:

SYS: DBA_AUDIT_TRAIL

SYS.DBA_AUDIT_SESSION is referenced by following:

PUBLIC: DBA_AUDIT_SESSION