Configuring Optimization Options

You can configure the options such as Enable Statement Caching and Fetch Buffer Size to modify the optimization behavior of the connector.

To configure optimization options:

1. To access optimization options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Optimization Options.
2. To enable statement caching, select the Enable Statement Caching check box and, in the Statement Cache Size field, specify the number of statements to cache.
3. To set the buffer size that the connector uses for data retrieval, in the Fetch Buffer Size field, type the size of the buffer in bytes.
4. To configure the round-trip timeout using the OCI_ATTR_CALL_TIMEOUT attribute, in the Query Timeout field, type the number of seconds that the connector waits for a round-trip call between the client and the server to complete before timing out and returning an error.
5. To determine the bind buffer length dynamically, select the Use Dynamic Bind Buffer check box.
6. To save your settings and close the Simba Oracle ODBC Driver DSN Setup dialog box, click OK.