| |
 |
|
DBA_AUDIT_EXISTS view tips
Oracle Tips by Burleson Consulting |
DBA_AUDIT_EXISTS
<< Return to the index
Oracle 11g makes the following comments about the DBA_AUDIT_EXISTS table: "Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS"
Related notes on DBA_AUDIT_EXISTS:
Column description of the DBA_AUDIT_EXISTS view:OS_USERNAMENo comments exist for the OS_USERNAME column of the DBA_AUDIT_EXISTS table. USERNAMENo comments exist for the USERNAME column of the DBA_AUDIT_EXISTS table. USERHOSTNo comments exist for the USERHOST column of the DBA_AUDIT_EXISTS table. TERMINALNo comments exist for the TERMINAL column of the DBA_AUDIT_EXISTS table. TIMESTAMPNo comments exist for the TIMESTAMP column of the DBA_AUDIT_EXISTS table. OWNERNo comments exist for the OWNER column of the DBA_AUDIT_EXISTS table. OBJ_NAMENo comments exist for the OBJ_NAME column of the DBA_AUDIT_EXISTS table. ACTION_NAMENo comments exist for the ACTION_NAME column of the DBA_AUDIT_EXISTS table. NEW_OWNERNo comments exist for the NEW_OWNER column of the DBA_AUDIT_EXISTS table. NEW_NAMENo comments exist for the NEW_NAME column of the DBA_AUDIT_EXISTS table. OBJ_PRIVILEGENo comments exist for the OBJ_PRIVILEGE column of the DBA_AUDIT_EXISTS table. SYS_PRIVILEGENo comments exist for the SYS_PRIVILEGE column of the DBA_AUDIT_EXISTS table. GRANTEENo comments exist for the GRANTEE column of the DBA_AUDIT_EXISTS table. SESSIONIDNo comments exist for the SESSIONID column of the DBA_AUDIT_EXISTS table. ENTRYIDNo comments exist for the ENTRYID column of the DBA_AUDIT_EXISTS table. STATEMENTIDNo comments exist for the STATEMENTID column of the DBA_AUDIT_EXISTS table. RETURNCODENo comments exist for the RETURNCODE column of the DBA_AUDIT_EXISTS table. CLIENT_IDNo comments exist for the CLIENT_ID column of the DBA_AUDIT_EXISTS table. ECONTEXT_IDNo comments exist for the ECONTEXT_ID column of the DBA_AUDIT_EXISTS table. SESSION_CPUNo comments exist for the SESSION_CPU column of the DBA_AUDIT_EXISTS table. EXTENDED_TIMESTAMPNo comments exist for the EXTENDED_TIMESTAMP column of the DBA_AUDIT_EXISTS table. PROXY_SESSIONIDNo comments exist for the PROXY_SESSIONID column of the DBA_AUDIT_EXISTS table. GLOBAL_UIDNo comments exist for the GLOBAL_UID column of the DBA_AUDIT_EXISTS table. INSTANCE_NUMBERNo comments exist for the INSTANCE_NUMBER column of the DBA_AUDIT_EXISTS table. OS_PROCESSNo comments exist for the OS_PROCESS column of the DBA_AUDIT_EXISTS table. TRANSACTIONIDNo comments exist for the TRANSACTIONID column of the DBA_AUDIT_EXISTS table. SCNNo comments exist for the SCN column of the DBA_AUDIT_EXISTS table. SQL_BINDNo comments exist for the SQL_BIND column of the DBA_AUDIT_EXISTS table. SQL_TEXTNo comments exist for the SQL_TEXT column of the DBA_AUDIT_EXISTS table. OBJ_EDITION_NAMENo comments exist for the OBJ_EDITION_NAME column of the DBA_AUDIT_EXISTS table.
DBA_AUDIT_EXISTS View SourceOracle 11g's data dictionary defines the DBA_AUDIT_EXISTS view using the following source query:
select os_username, username, userhost, terminal, timestamp,
owner, obj_name,
action_name,
new_owner,
new_name,
obj_privilege, sys_privilege, grantee,
sessionid, entryid, statementid, returncode, client_id,
econtext_id, session_cpu,
extended_timestamp, proxy_sessionid, global_uid, instance_number,
os_process, transactionid, scn, sql_bind, sql_text, obj_edition_name
from dba_audit_trail
where returncode in
(942, 943, 959, 1418, 1432, 1434, 1435, 1534, 1917, 1918, 1919, 2019,
2024, 2289,
4042, 4043, 4080, 1, 951, 955, 957, 1430, 1433, 1452, 1471, 1535, 1543,
1758, 1920, 1921, 1922, 2239, 2264, 2266, 2273, 2292, 2297, 2378, 2379,
2382, 4081, 12006, 12325)
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
