Poor Performance With Pricing Queries When Making Call to Price_Request API
(Doc ID 2803771.1)
Last updated on NOVEMBER 01, 2021
Applies to:Oracle Advanced Pricing - Version 12.1 and later
Information in this document applies to any platform.
On : 12.1.3 version, System Tuning Issue
Performance Issue with Pricing Query while calling API QP_PREQ_PUB.PRICE_REQUEST
There is one query that is top of AWR report for
* SQL ordered by Elapsed Time
* SQL ordered by CPU Time
* SQL ordered by Sharable Memory
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document