skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Wire Protocol Driver : Connection Option Descriptions : Cached Cursor Limit
  
Cached Cursor Limit
Attribute
CachedCursorLimit (CCL)
Purpose
Specifies the number of Oracle Cursor Identifiers that the driver stores in cache. A Cursor Identifier is needed for each concurrent open Select statement. When a Select statement is closed, the driver stores the identifier in its cache, up to the limit specified, rather than closing the Cursor Identifier. When a new Cursor Identifier is needed, the driver takes one from its cache, if one is available. Cached Cursor Identifiers are closed when the connection is closed.
Valid Values
An integer from 0 to 65535
Default
32
GUI Tab
Performance tab
See also
Performance Considerations