Statement Cache Size
This option indicates the number of statements that the statement cache can contain. Even though the Simba Oracle ODBC Driver does not place any restriction on the size of the statement cache, you must be aware of the maximum number of open cursors allowed in your data source. For example, if the cache size is set to a value higher than the maximum number of open cursors allowed in your data source, you may see an error such as the following:
ORA-01000: maximum open cursors exceeded
We recommend that you turn on auto-tuning with the connection-specific parameters such as prefetch and statement_cache for performance improvements. For more information, see the following:
- For information about OCI auto-tuning, see "Client Statement Cache Auto-Tuning" in the Oracle Call Interface Programmer’s Guide:https://docs.oracle.com/database/121/LNOCI/oci10new.htm#LNOCI73051.
- For information about
oraacess.xml, see "OCI Client-Side Deployment Parameters Using oraaccess.xml" in the Oracle Call Interface Programmer’s Guide: https://docs.oracle.com/database/121/LNOCI/oci10new.htm#LNOCI-GUID-CD599644-135A-4116-8B3B-40A9BA172E5C. - For information about fetching results with OCI, see "About Fetching Results" in the Oracle Call Interface Programmer’s Guide: https://docs.oracle.com/database/121/LNOCI/oci04sql.htm#LNOCI1635.
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |