OPEN_CURSORS
This specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors.
| Property | Description |
| Parameter type | Integer |
| Default value | 50 |
| Modifiable | ALTER SYSTEM |
| Range of values | 1 to 4294967295 (4 GB -1) |
| Recommended Value | 5000 |
Oracle FLEXCUBE relevance
It is important to set the value of OPEN_CURSORS high enough to prevent FLEXCUBE application from running out of open cursors (ORA-01000: maximum open cursors exceeded).
Parent topic: Database Initialization Parameters