Specifies whether statement caching is enabled and the maximum number of statements to cache.
O10 Oracle 10g
ORA Oracle 11g
StatementCache='value'
Parameter |
Description |
|---|---|
value |
Specifies whether statement caching is enabled and the maximum number of statements to cache. Values are:
|
StatementCache=0
Statement caching in Oracle 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 or session pooling to improve performance and scalability.
To enable statement caching and specify that five statements can be cached:
Database profile Type 5 in the Number of Oracle Statements Cached box on the Transaction page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="StatementCache=5"
