DBA Data[Home] [Help]

VIEW: SYS.CDB_AUDIT_SESSION

Source

View Text - Preformatted

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","CON_ID" FROM CONTAINERS("SYS"."DBA_AUDIT_SESSION")
View Text - HTML Formatted

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"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_AUDIT_SESSION")