What is Audit Action 103 ?
(Doc ID 208855.1)
Last updated on FEBRUARY 23, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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.
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
For all DBAs who need to be careful about the SYS.AUD$ table growth and manage appropriate cleanup.
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 , 126.96.36.199 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!