Table Space Filling Up Fast In ESB Production Database. (Doc ID 2890723.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Goal

The issue is with AUDIT_TRAIL table. Table Space filling up fast in ESB Production database and we need to do the purging of ESB tables to reduce tablespace. But this activity is performed in a frequent basis, hence we cannot we recent logs.

We need solution how we can reduce fast filling of tablespace and also how to keep a backup of minimum 2 months data before purging.
 

Solution

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