Property | Description |
Parameter type | Integer |
Default value |
|
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 |
No comments:
Post a Comment