Database - RAC/Scalability (MOSC)

MOSC Banner

How should I manage the size the large audit tables?

Hello,

I have been asked to manage the audit tables (only aud$) for production databases. The size of the audit tables are quite large (>45GB). I cross-checked some answers in the Oracle community, many of the answers involve moving the audit trail tables using procedure DBMS_AUDIT_MGMT. (Doc ID 1328239.1)

But my case has a small difference. The audit tablespace has already been assigned to a different existing tablespace (not SYSTEM tablespace). How can I manage the audit tables in this case? Also, is it safe to truncate, delete, or purge rows from the Audit Trail Table AUD$? If so, how can I proceed?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center