OS_USERNAME
|
VARCHAR2(255)
|
|
Operating system login username of the user whose actions were audited
|
USERNAME
|
VARCHAR2(30)
|
|
Name (not ID number) of the user whose actions were audited
|
USERHOST
|
VARCHAR2(2000)
|
|
Numeric instance ID for the Oracle instance from which the user is accessing the database
|
TERMINAL
|
VARCHAR2(2000)
|
|
Identifier of the user's terminal
|
TIMESTAMP
|
DATE
|
NOT NULL
|
Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
|
ACTION_NAME
|
VARCHAR2(27)
|
|
Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
|
LOGOFF_TIME
|
DATE
|
|
Timestamp for user log off
|
LOGOFF_LREAD
|
NUMBER
|
|
Logical reads for the session
|
LOGOFF_PREAD
|
NUMBER
|
|
Physical reads for the session
|
LOGOFF_LWRITE
|
NUMBER
|
|
Logical writes for the session
|
LOGOFF_DLOCK
|
VARCHAR2(40)
|
|
Deadlocks detected during the session
|
SESSIONID
|
NUMBER
|
NOT NULL
|
Numeric ID for each Oracle session
|
RETURNCODE
|
NUMBER
|
NOT NULL
|
Oracle error code generated by the action. Some useful values:
0 : the action succeeded
2004 : security violation
|
CLIENT_ID
|
VARCHAR2(64)
|
|
Client identifier in each Oracle session
|
SESSION_CPU
|
NUMBER
|
|
Amount of CPU time used by each Oracle session
|