My Oracle Support Banner

Performance Issue When Purging The OWB Audit Data Using purge_audit_template.sql (Doc ID 1358470.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Warehouse Builder - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Purging the OWB Runtime Audit data by executing the function WB_RT_API_PURGE.PURGE_EXECUTION when running the script <OWB_HOME>/owb/rtp/sql/purge_audit_template.sql shows a very poor performance: it takes a very long time to execute.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 For OWB 10.2.0.4
 For OWB 11.1.0.6
 For OWB 11.2.0.2
 For OWB 11.2.0.3
References


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