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 and later
Information in this document applies to any platform.


PLP_APXACTSGROUPACCOUNT_A_STAGE Session has been running for 34 hours.


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 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.


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