My Oracle Support Banner

Performance Issues Caused by DB Collector When AUD$ Is Very Large (Full Table Scan on AUD$) (Doc ID 1356088.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Audit Vault - Version 10.2.3.2 and later
Information in this document applies to any platform.
 

Symptoms

The database collector of the Audit Vault causes massive performance issues on source databases because of time consuming full table scans on the aud$ table. This happens when the aud$ table is very large.
The statement found in top of the AWR report is:




Cause

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

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

In this Document
Symptoms
Cause
Solution
References


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