StatementCache
database parameter
Description
Specifies whether statement caching is enabled and the maximum
number of statements to cache.
Applies to
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
|
1 |
StatementCache='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether statement caching is enabled and
|
Default value
StatementCache=0
Usage
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.
Examples
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:
1SQLCA.DBParm="StatementCache=5"
See also