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 dba_audit_trail
where action between 100 and 102
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 DBA_AUDIT_TRAIL
WHERE ACTION BETWEEN 100
AND 102
|
|
|