[Home] [Help] [Dependency Information]
Object Name: | USER_AUDIT_SESSION |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All audit trail records concerning CONNECT and DISCONNECT
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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.USER_AUDIT_SESSION;
|
|
|