D.35 HS_OPEN_CURSORS

HS_OPEN_CURSORS initialization parameters for Oracle Database Gateway for Sybase.

Property Description

Default value

50

Range of values

1 to the value of Oracle's OPEN_CURSORS initialization parameter

Defines the maximum number of cursors that can be open on one connection to a non-Oracle system instance.

The value never exceeds the number of open cursors in the Oracle database. Therefore, setting the same value as the OPEN_CURSORS initialization parameter in the Oracle database is recommended.