Is There A Quicker Way To Cleanup Table WWSSO_AUDIT_LOG_TABLE_T Beside Running Cleanup_audit_log? (Doc ID 1583471.1)

Last updated on SEPTEMBER 19, 2013

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.4.0.1 to 10.1.4.3 [Release 10gR3]
Information in this document applies to any platform.

Goal

The SSO WWSSO_AUDIT_LOG_TABLE_T table in production environment may have over a million rows, containing several years of data.

Given the size of the table and the potential time needed to run the cleanup procedure in production environment, is there a way to clean up the table in different time frames to minimize the downtime or access to the system?

 

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms