[ORACLE], [SYBASE]
max_max_cursors=100 (or 0)
Possible settings: 1 (or 0 after build 96) to maximum of open_cursors parameter in the Oracle database INIT<SID>.ORA file
This is the maximum number of cursors that auxoracl will attempt to open in Oracle. When this number, the limit across all connections, is reached, it begins to close cursors to make them available for reuse. The advantage of the seemingly high devault value is that it keeps cursors open. When cursors associated with SQL statements have been closed, they have to be re-parsed within Oracle. Keeping cursors open avoids this and reduces traffic across the network, speeding up processing.
As of build 96 of AUXORACL there is usually no reason to limit cursors in this way (it can result in an "unfair" division of cursors between different users), and you may specify a limit of 0, which is the default from build 97 on
The meaning of the variable is identical. However we do not have any information about the maximum value allowed, nor the effect on performance of changing it.