Database Administration (MOSC)

MOSC Banner

Purge Table AUD$ regularly

edited Nov 14, 2019 4:38PM in Database Administration (MOSC) 9 commentsAnswered ✓

Hello,

Oracle 11.2.0.1 Vanilla (no patches)

My audit table AUD$ grew in SYSTEM till 28 GB

I moved AUD$ to dedicated TBS AUDIT_TBS following article: How To Move The DB Audit Trails To A New Tablespace Using DBMS_AUDIT_MGMT? (Doc ID 1328239.1)

Tablespace        Tbsp %                                                     Allocated    Current    Current File %

Name                Free Filename                                                   GB    Used GB    Free GB   Free

----------------- ------ -------------------------------------------------- ---------- ---------- ---------- ------

AUDIT_TBS           11.7 /home/oracle/app/oracle/oradata/orcl/audit_tbs1.db     31.000     27.376      3.624   11.7

SYSTEM         97.9 /home/oracle/app/oracle/oradata/orcl/system01.dbf 31.953 0.68731.266   97.9

All auditing tables are in new TBS:

TABLE_NAME                TABLESPACE_NAME

------------------------------ ------------------------------

AUD$                      AUDIT_TBS
FGA_LOG$                 
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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center