disable cache

Use

Use this setting only for analysis and testing, for example, to ensure that the cache is not returning the wrong statement.

Caution: Using this option can significantly degrade performance. It is recommended that it not be used in a production environment.

Description

The Oracle connector cache ensures that a statement put into the cache is prepared and bound, and that a cursor is opened.

Setting the disable cache option ensures that only most recent statement put into the cache is held there. Caching a second statement causes the first to be removed from the cache, so the next time it is required, the statement must be prepared and bound again. This can negatively affect performance.

If you use the disable cache option, you can limit the performance decrease by using cursor caching on the server side. Tune the Oracle server by configuring the SESSION_CACHED_CURSORS parameter.

You can experience the difference by altering the session after the application has started using an SQL statement such as:

alter session set session_cached_cursors = 100