Enable Automatic Degree of Parallelism (Auto DOP) For ORMB Application Database
(Doc ID 2988509.1)
Last updated on NOVEMBER 21, 2023
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 to 5.1.0.0.0 [Release 2 to 5.0]Information in this document applies to any platform.
Goal
We are facing lot of Performance related issue with UI as well batch programs running in ORMB application. And on analysis we found that the SQL running behind this programs are taking too much time during executions and we fine tuned many queries and created indexes. But still we have some performance issue.
Another way tried to improve the performance is that by Enabling the Automatic Degree of Parallelism (Auto DOP) for the Database (DB).
Is there any functional or technical impact on ORMB application if we enable Auto DOP for the DB?
Solution
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
| Goal |
| Solution |
| References |