My Oracle Support Banner

Recommended Cache and Open Cursor Values (Doc ID 2433763.1)

Last updated on OCTOBER 16, 2018

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.16.1.0.0 and later
Information in this document applies to any platform.

Goal

If cache size is changed from 10 to 200, what is the open cursor parameter value? Because this cache statement size and open cursor parameters are dependent, knowing the impact/improvement on the performance would be helpful.
 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.