Last updated on NOVEMBER 30, 2016
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
- OBI Apps: 126.96.36.199.1
- Source: EBS
- Source db/Target db: 188.8.131.52/184.108.40.206
- 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 220.127.116.11.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
Million Knowledge Articles and hundreds of Community platforms