My Oracle Support Banner

A_DW_TXN_LOG Table And Index Are Growing Huge And Affecting Disk Space Even For Non-OPLA Users (Doc ID 2051851.1)

Last updated on JULY 09, 2019

Applies to:

Oracle Agile PLM Framework - Version 9.3.1.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

A_DW_TXN_LOG table and index are growing huge (i.e. 16 GB) every weeks and impacts disk space even though Oracle Product Lifecycle Analytics (OPLA) is not used

Expected Behavior

Stop the inserts into A_DW_TXN_LOG

Steps
1. Have the Agile Application Server running for 4 weeks
2. Check the size of A_DW_TXN_LOG table and its index

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
References


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