DBA_STMT_AUDIT_OPTS view tips

Oracle Tips by Burleson Consulting

DBA_STMT_AUDIT_OPTS

<< Return to the index

Oracle 11g makes the following comments about the DBA_STMT_AUDIT_OPTS table: "Describes current system auditing options across the system and by user"

Related notes on DBA_STMT_AUDIT_OPTS:

Column description of the DBA_STMT_AUDIT_OPTS view:

USER_NAME

Description of DBA_STMT_AUDIT_OPTS.USER_NAME: "User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done"

PROXY_NAME

Description of DBA_STMT_AUDIT_OPTS.PROXY_NAME: "Name of the proxy user if auditing is being done for operations being done on behalf of a client. Null if auditing is being done for operations done by the client directly"

AUDIT_OPTION

Description of DBA_STMT_AUDIT_OPTS.AUDIT_OPTION: "Name of the system auditing option"

SUCCESS

Description of DBA_STMT_AUDIT_OPTS.SUCCESS: "Mode for WHENEVER SUCCESSFUL system auditing"

FAILURE

Description of DBA_STMT_AUDIT_OPTS.FAILURE: "Mode for WHENEVER NOT SUCCESSFUL system auditing"

DBA_STMT_AUDIT_OPTS View Source

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

select decode(aud.user#, 0 /* client operations through proxy */, 'ANY CLIENT',
1 /* System wide auditing*/, null,
client.name)
/* USER_NAME */,
proxy.name /* PROXY_NAME */,
aom.name /* AUDIT_OPTION */,
decode(aud.success, 1, 'BY SESSION', 2, 'BY ACCESS', 'NOT SET')
/* SUCCESS */,
decode(aud.failure, 1, 'BY SESSION', 2, 'BY ACCESS', 'NOT SET')
/* FAILURE */
from sys.user$ client, sys.user$ proxy, STMT_AUDIT_OPTION_MAP aom,
sys.audit$ aud
where aud.option# = aom.option#
and aud.user# = client.user#
and aud.proxy# = proxy.user#(+)

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