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 server message code generated by the action. Some useful values:
0 : the action succeeded
2004 : security violation
|