What is Audit Action 103 ? (Doc ID 208855.1)

Last updated on FEBRUARY 23, 2023

Applies to:

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