[Home] [Help] [Dependency Information]
Object Name: | AUD$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000000090C00040$$ | LOB | UNIQUE | SYSAUX | |
SYS_IL0000000090C00041$$ | LOB | UNIQUE | SYSAUX |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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$;
SYS.AUD$ does not reference any database object
SYS.AUD$ is referenced by following:
|
|
|