BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck

DBA_AUDIT_OBJECT view tips

Oracle Tips by Burleson Consulting

DBA_AUDIT_OBJECT

<< Return to the index

Oracle 11g makes the following comments about the DBA_AUDIT_OBJECT table: "Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user"

Related notes on DBA_AUDIT_OBJECT:

Column description of the DBA_AUDIT_OBJECT view:

INSTANCE_NUMBER

No comments exist for the INSTANCE_NUMBER column of the DBA_AUDIT_OBJECT table.

OS_PROCESS

No comments exist for the OS_PROCESS column of the DBA_AUDIT_OBJECT table.

TRANSACTIONID

No comments exist for the TRANSACTIONID column of the DBA_AUDIT_OBJECT table.

SCN

No comments exist for the SCN column of the DBA_AUDIT_OBJECT table.

SQL_BIND

No comments exist for the SQL_BIND column of the DBA_AUDIT_OBJECT table.

SQL_TEXT

No comments exist for the SQL_TEXT column of the DBA_AUDIT_OBJECT table.

OBJ_EDITION_NAME

No comments exist for the OBJ_EDITION_NAME column of the DBA_AUDIT_OBJECT table.

OS_USERNAME

No comments exist for the OS_USERNAME column of the DBA_AUDIT_OBJECT table.

USERNAME

No comments exist for the USERNAME column of the DBA_AUDIT_OBJECT table.

USERHOST

No comments exist for the USERHOST column of the DBA_AUDIT_OBJECT table.

TERMINAL

No comments exist for the TERMINAL column of the DBA_AUDIT_OBJECT table.

TIMESTAMP

No comments exist for the TIMESTAMP column of the DBA_AUDIT_OBJECT table.

OWNER

No comments exist for the OWNER column of the DBA_AUDIT_OBJECT table.

OBJ_NAME

No comments exist for the OBJ_NAME column of the DBA_AUDIT_OBJECT table.

ACTION_NAME

No comments exist for the ACTION_NAME column of the DBA_AUDIT_OBJECT table.

NEW_OWNER

No comments exist for the NEW_OWNER column of the DBA_AUDIT_OBJECT table.

NEW_NAME

No comments exist for the NEW_NAME column of the DBA_AUDIT_OBJECT table.

SES_ACTIONS

No comments exist for the SES_ACTIONS column of the DBA_AUDIT_OBJECT table.

COMMENT_TEXT

No comments exist for the COMMENT_TEXT column of the DBA_AUDIT_OBJECT table.

SESSIONID

No comments exist for the SESSIONID column of the DBA_AUDIT_OBJECT table.

ENTRYID

No comments exist for the ENTRYID column of the DBA_AUDIT_OBJECT table.

STATEMENTID

No comments exist for the STATEMENTID column of the DBA_AUDIT_OBJECT table.

RETURNCODE

No comments exist for the RETURNCODE column of the DBA_AUDIT_OBJECT table.

PRIV_USED

No comments exist for the PRIV_USED column of the DBA_AUDIT_OBJECT table.

CLIENT_ID

No comments exist for the CLIENT_ID column of the DBA_AUDIT_OBJECT table.

ECONTEXT_ID

No comments exist for the ECONTEXT_ID column of the DBA_AUDIT_OBJECT table.

SESSION_CPU

No comments exist for the SESSION_CPU column of the DBA_AUDIT_OBJECT table.

EXTENDED_TIMESTAMP

No comments exist for the EXTENDED_TIMESTAMP column of the DBA_AUDIT_OBJECT table.

PROXY_SESSIONID

No comments exist for the PROXY_SESSIONID column of the DBA_AUDIT_OBJECT table.

GLOBAL_UID

No comments exist for the GLOBAL_UID column of the DBA_AUDIT_OBJECT table.

DBA_AUDIT_OBJECT View Source

Oracle 11g's data dictionary defines the DBA_AUDIT_OBJECT view using the following source query:

select OS_USERNAME, USERNAME, USERHOST, TERMINAL, TIMESTAMP,
OWNER, OBJ_NAME, ACTION_NAME, NEW_OWNER, NEW_NAME,
SES_ACTIONS, COMMENT_TEXT, SESSIONID, ENTRYID, STATEMENTID,
RETURNCODE, PRIV_USED, 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 (action between 1 and 16)
or (action between 19 and 29)
or (action between 32 and 41)
or (action = 43)
or (action between 51 and 99)
or (action = 103)
or (action between 110 and 113)
or (action between 116 and 121)
or (action between 123 and 128)
or (action between 160 and 162)

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

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books