SESSION_CACHED_CURSORS

SESSION_CACHED_CURSORS specifies the number of session cursors to cache. Repeated parse calls of the same SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Subsequent parse calls will find the cursor in the cache, and do not need to reopen the cursor. Performance of Oracle Hyperion Financial Management applications will benefit from this cache because Financial Management connections are also cached.

Suggested setting: 50