Limit Fetch Query Is Taking Very High Cost and Impacting The Performance
(Doc ID 2897618.1)
Last updated on OCTOBER 19, 2022
Applies to:
Oracle Banking Digital Experience - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.1.0.0.0 version, Implementation Support
ACTUAL BEHAVIOR
---------------
Limit related query is taking very high cost impact the performance . This is making DB CPU utilization of 100% for 1000 concurrent users.
EXPECTED BEHAVIOR
-----------------------
Query should not consume 100% CPU utilization and should be tuned.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, CPU uses 100% utilization.
Changes
No changes done to product, account or hardware causes this issue.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |