Note
This parameter was introduced in V2.2.77.
Description
The open_cursors parameter specifies the maximum number of cursors that a session can open at the same time.
Privilege requirements
Query the parameter
You can use the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter in thesystenant and the MySQL user tenant.Modify the parameter
You can modify this parameter in the
systenant and the MySQL user tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 50 |
| Value range | [0, 65535] |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
The maximum number of cursors that a session can open at the same time. If a session opens more than this number of cursors, an error
ORA-01000: maximum open cursors exceeded.is returned.The
open_cursorsparameter limits both the number of cursors and the number of PS handles.
Example
The following example sets the maximum number of cursors that a session can open at the same time to 20:
obclient> ALTER SYSTEM SET open_cursors = 20;