Limiting the Number of Cursors

Set the MAX_CURSOR_COUNT option to prevent a single connection from taking too much available memory or CPU resources.

The MAX_CURSOR_COUNT option limits the maximum number of cursors that a connection can use at once. The default is 50. Setting this option to 0 allows an unlimited number of cursors.