Since init parameters such as “sessions” and “open_cursors” can not be modified in Autonomous Transaction Processing (ATP). Is there any best practice guideline to size ATP (number of OCPUs) for APEX on ATP?
Asked
Active
Viewed 294 times
1 Answers
0
There are 2 settings for sizing Autonomous Database (ADW, ATP). Number of OCPUs and Terabytes of data. All other settings are derived from those 2 settings. The number of sessions is a function of the number of OCPUs. You can query the database to see what settings are currently active based on your OCPU setting.
Additionally, note that auto-scale for CPU allows the database to consume more OCPU temporarily when required, but does not increase things like the number of sessions.
PS - I am a product manager for Oracle Autonomous Database (ADB)
Nilay Panchal
- 541
- 6
- 17