Friday, November 7, 2008

OPEN_LINKS_PER_INSTANCE

Property

Description

Parameter type

Integer

Default value

4

Modifiable

No

Range of values

0 to 4294967295 (4 GB -1)

Real Application Clusters

Multiple instances can have different values.

OPEN_LINKS_PER_INSTANCE specifies the maximum number of migratable open connections globally for each database instance. XA transactions use migratable open connections so that the connections are cached after a transaction is committed. Another transaction can use the connection, provided the user who created the connection is the same as the user who owns the transaction.

OPEN_LINKS_PER_INSTANCE is different from OPEN_LINKS, which indicates the number of connections from a session. The OPEN_LINKS parameter is not applicable to XA applications.

Note:

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘OPEN_LINKS_PER_INSTANCE’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

open_links_per_instance

4

TRUE

FALSE

FALSE

FALSE

FALSE

max # open links per instance

Oracle initializatoin parameters

No comments:

Post a Comment