This parameter is used to specify the number of open cursors each session can have at once. It is used to prevent session from opening more cursors.
Value for this parameter: If a session does not open the number of cursors specified by OPEN_CURSORS, there will not be any overhead to setting this value higher than actually needed.
OPEN_CURSORS simply allocates a fixed number of slots but does not allocate memory for these slots for a client (eg: it sets an array up to have 1,000 cursors for example but does not allocate 1,000 cursors).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment