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 SEPTEMBER 01, 2017

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

Cause

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