2.10 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 Values | 5000 |
Oracle Banking Trade Finance relevance
It is important to set the value of OPEN_CURSORS high enough to prevent Oracle Banking Trade Finance application from running out of open cursors (ORA-01000: maximum open cursors exceeded).
Parent topic: Database Initialization Parameters