Incremental Load Performance Issue with PLP_APXACTSGROUPACCOUNT_A_STAGE Session, It Has Been Running for More Than 34 Hours
Last updated on NOVEMBER 30, 2016
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
- OBI Apps: 220.127.116.11.1
- Source: EBS
- Source db/Target db: 18.104.22.168/22.214.171.124
- Load: Incremental
PLP_APXACTSGROUPACCOUNT_A_STAGE Session has been running for 34 hours.
PLP_PLP_APXACTSGROUPACCOUNT_A_STAGE details show:
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 126.96.36.199.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.
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