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. Oracle uses a least recently used algorithm to remove entries in the session cursor cache to make room for new entries when needed.
| Property | Description |
| Parameter type | Integer |
| Default value | 50 |
| Recommended Value | 400 |
| Range of values | 0 to operating system-dependent |
Oracle FLEXCUBE relevance
This helps to cache the cursor thus avoid parsing of the cursor which heavy CPU intensive particularly in batch.
Parent topic: Database Initialization Parameters