My Oracle Support Banner

What is Audit Action 103 ? (Doc ID 208855.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2.0.4 [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Checked for relevance on 12-Jun-2013


Purpose

Audit, once activated, may generate many 103 action rows in SYS.AUD$ table.
This is displayed
--> in SYS.AUD$ table in column ACTION# or
--> in DBA_AUDIT_TRAIL view in column ACTION

This bulletin explains:

--> What is Action 103
--> Under which form Action 103 records are displayed
--> Examples of how action 103 records are generated
--> How to interpret action 103

Scope


For all DBAs who need to be careful about the SYS.AUD$ table growth and manage appropriate cleanup.

Comment:

This document specifically applies to RDBMS versions up to 10.2.0.4, in more recent versions this behaviour has changed, also see <note 6023472.8> . In versions 10.2.0.5 , 11.1.0.7 and upwards, if you specify BY SESSION auditing, each audited action, even in the same session will generate a new audit record, however the format of the audit record was not changed and you will still see audit action 103 in that case, to get more detailed information, it is recommended to convert all currently configured BY SESSION auditing to BY ACCESS, you can use <note 287436.1> for this purpose.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.