Audit Data Purges and Oracle Database Tablespace

Issue: After repeated purging of audit data using Shared Services, table space is not freed in Oracle database.

Note:

In Oracle database, table space is not freed automatically when you delete the data from the tables.

Solution: Follow these steps:

  1. Stop the Shared Services server and run these queries to shrink the space occupied by the tables:

    alter table SMA_AUDIT_ATTRIBUTE_FACT enable row movement 
alter table SMA_AUDIT_ATTRIBUTE_FACT shrink space 

alter table SMA_AUDIT_FACT enable row movement 
alter table SMA_AUDIT_FACT shrink space

  2. Restart the Shared Services server.