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.AUD$

Object Details

Object Name:	AUD$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000000090C00040$$	LOB	UNIQUE	SYSAUX
SYS_IL0000000090C00041$$	LOB	UNIQUE	SYSAUX

Columns

Name	Datatype	Length	Mandatory
SESSIONID	NUMBER		Yes
ENTRYID	NUMBER		Yes
STATEMENT	NUMBER		Yes
TIMESTAMP#	DATE
USERID	VARCHAR2	(128)
USERHOST	VARCHAR2	(128)
TERMINAL	VARCHAR2	(255)
ACTION#	NUMBER		Yes
RETURNCODE	NUMBER		Yes
OBJ$CREATOR	VARCHAR2	(128)
OBJ$NAME	VARCHAR2	(128)
AUTH$PRIVILEGES	VARCHAR2	(16)
AUTH$GRANTEE	VARCHAR2	(128)
NEW$OWNER	VARCHAR2	(128)
NEW$NAME	VARCHAR2	(128)
SES$ACTIONS	VARCHAR2	(19)
SES$TID	NUMBER
LOGOFF$LREAD	NUMBER
LOGOFF$PREAD	NUMBER
LOGOFF$LWRITE	NUMBER
LOGOFF$DEAD	NUMBER
LOGOFF$TIME	DATE
COMMENT$TEXT	VARCHAR2	(4000)
SPARE1	VARCHAR2	(255)
SPARE2	NUMBER
OBJ$LABEL	RAW	(255)
SES$LABEL	RAW	(255)
PRIV$USED	NUMBER
CLIENTID	VARCHAR2	(128)
SESSIONCPU	NUMBER
NTIMESTAMP#	TIMESTAMP(6)	(11)
PROXY$SID	NUMBER
USER$GUID	VARCHAR2	(32)
INSTANCE#	NUMBER
PROCESS#	VARCHAR2	(16)
XID	RAW	(8)
AUDITID	VARCHAR2	(64)
SCN	NUMBER
DBID	NUMBER
SQLBIND	CLOB	(4000)
SQLTEXT	CLOB	(4000)
OBJ$EDITION	VARCHAR2	(128)

Query Text

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


SELECT SESSIONID
,      ENTRYID
,      STATEMENT
,      TIMESTAMP#
,      USERID
,      USERHOST
,      TERMINAL
,      ACTION#
,      RETURNCODE
,      OBJ$CREATOR
,      OBJ$NAME
,      AUTH$PRIVILEGES
,      AUTH$GRANTEE
,      NEW$OWNER
,      NEW$NAME
,      SES$ACTIONS
,      SES$TID
,      LOGOFF$LREAD
,      LOGOFF$PREAD
,      LOGOFF$LWRITE
,      LOGOFF$DEAD
,      LOGOFF$TIME
,      COMMENT$TEXT
,      SPARE1
,      SPARE2
,      OBJ$LABEL
,      SES$LABEL
,      PRIV$USED
,      CLIENTID
,      SESSIONCPU
,      NTIMESTAMP#
,      PROXY$SID
,      USER$GUID
,      INSTANCE#
,      PROCESS#
,      XID
,      AUDITID
,      SCN
,      DBID
,      SQLBIND
,      SQLTEXT
,      OBJ$EDITION
FROM SYS.AUD$;

Dependencies

[top of page]

SYS.AUD$ does not reference any database object

SYS.AUD$ is referenced by following:

SYS: DBA_AUDIT_TRAIL