Statement caching in Oracle 10g provides and manages a cache of statements for each session. On the server, cursors are ready to be used without the need to parse the statement again before execution. Statement caching can be used with connection pooling and improves performance and scalability.
To set the maximum size of the statement cache, set the StatementCache DBParm to the number of statements you want to cache. The default value is 0, which means that statement caching is disabled in the current session. This DBParm is available only in the O10 database interface.