Try OpenEdge Now
skip to main content
DataServer for Oracle
Additional Features to Enhance DataServer Performance : Closing inactive cursors
 

Closing inactive cursors

In a use case where the OpenEdge application faces the possibility of exceeding the limit on available cursors, it is recommended that you increase the limit of the OpenEdge index cursor (-c) parameter. For more information on OpenEdge Index cursors, see Index cursors. Note that the maximum value you can specify for the -c parameter depends on the maximum value you specified for the OPEN_CURSORS parameter in the init.ora file.
If there is a chance that you will exceed the maximum number of cursors specified by the -c parameter, then you must close inactive cursors using the RDBMS stored procedure statement, RUN STORED-PROC ds-close-cursor. For more information on the cursor closer operation, see RUN STORED-PROC statement with special internal option.