HomePowerBuilderAppeon Documentation Center

StatementCache

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

StatementCache='value'

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 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:

    SQLCA.DBParm="StatementCache=5"

See also

CnnPool

Pooling

Prev  Up  Next
SQLCache  Home  StaticBind