HomePowerBuilderAppeon Documentation Center

RTConnBalancing

Description

Supports the runtime connection load balancing feature.

Applies to

ORA Oracle (for 11g and later)

Syntax

RTConnBalancing =value

Parameter

Description

value

Specifies whether the load balancing feature is used. Values are:

  • True

    (Default) The load balancing feature is used if session pooling is set.

  • False

    The load balancing feature is not used.

Default value

True, but this value is ignored if session pooling is not set.

Usage

Runtime connection load balancing routs work requests to the sessions in a session pool that best serve the work. Runtime connection load balancing is enabled by default when an Oracle 11.1 or higher client is connected to a release 10.2 or higher Oracle server using OCI session pooling.

Examples

The following code disables the load balancing feature in a session pool:

  • Database profile

    Select Session Pooling from the Pooling Type drop-down list on the Pooling page in the Database Profile Setup dialog box and clear the Runtime Connection Load Balancing for Session Pooling check box on the same page.

  • Application

    Type the following in code:

    my_trans.dbparm ="pooling='session', rtconnbalancing='No'"

See also

Pooling

Prev  Up  Next
ReturnCommandHandle  Home  Scroll