Incremental Load Performance Issue with PLP_APXACTSGROUPACCOUNT_A_STAGE Session, It Has Been Running for More Than 34 Hours (Doc ID 2165334.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

PLP_APXACTSGROUPACCOUNT_A_STAGE Session has been running for 34 hours.

PLP_PLP_APXACTSGROUPACCOUNT_A_STAGE details show:

Record Statistics: 3,516,972 inserts, 0 updates, 0 deletes, 0 errors,
3,516,974 # rows


Calculated Rows per sec: 3,516,974 rows / 119393 seconds = 33.2 rows per second

User has followed the tech document in <Note 2022245.1> OBIA 11.1.1.8.1: PLP_PLP_APXACTSGROUPACCOUNT_A_STAGE Scenario Is Running For Long Time In Incremental Load, which adds hint of /*+ FULL(W_AP_XACT_F) */.

However, this did not improve performance at all.

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