My Oracle Support Banner

How To Find Audit Objects For All The Audit Groups? (Doc ID 298136.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Application Object Library - Version 11.5.1 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Reviewed for Relevance 29 Jul 18.

Goal

 

When there are issues related to the Concurrent Program Audit Trail Update Tables not completing successfully, it is often required to know which Audit Groups exist, their status (Disable - Purge Table,Enabled,Disable - Prepare for Archive, Disable - Interrupt Audit, Enable Requested), the tables being audited that belong to them and the database objects (indexes, shadow tables, triggers, procedures, views and Synonyms) corresponding to the tables being audited.

Need to know how this is done.

Solution

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.