StatementCache database parameter

Description

Specifies whether
statement caching is enabled and the maximum number of statements
to cache.

Controls

• O10 Oracle 10g

• ORA Oracle 11g

Syntax

Parameter	Description
value	Specifies whether statement caching is enabled and the maximum number of statements to cache. Values are: 0 Statement caching is disabled. n Statement caching is enabled and n statements may be cached, where n is a positive integer.

Default

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

See Also

• CnnPool

• Pooling

---