Note
This parameter is introduced since OceanBase Database V2.2.77.
Description
open_cursors specifies the maximum number of cursors that can be opened at one time in a single session.
Applicability
This parameter is only applicable to the Oracle mode of OceanBase Database.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 50 |
| Value range | [0, 65535] |
| Modifiable | Yes. It can be modified using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No |
Considerations
If the number of open cursors on a session exceeds this limit, an error ORA-01000: maximum open cursors exceeded is reported.
Examples
Here is an example of setting the number of concurrently opened cursors of a session to 20:
obclient> ALTER SYSTEM SET open_cursors = 20;