Oracle 参数 OPEN_LINKS_PER_INSTANCE 官方解释，作用，如何配置最优化建议
本站中文解释
OPEN_LINKS_PER_INSTANCE参数用于控制在Oracle实例中最多允许的并发外部链接的数量。
为了正确设置OPEN_LINKS_PER_INSTANCE参数，必须考虑到外部链接需要多少个数据库用户。设置该参数的值为实际需要的数量加1。另外，还需要注意，如果该数值设置过大，可能会造成服务器内存不足的问题。
另外，还可以通过以下步骤来正确设置OPEN_LINKS_PER_INSTANCE参数：
1.使用以下命令查询Oracle实例中连接的数量：
select count(*) from v$external_link;
2. 设置OPEN_LINKS_PER_INSTANCE参数为查询结果加1。
3. 重新启动实例，使设置生效：
shutdown immediate;
startup;
官方英文解释
OPEN_LINKS_PER_INSTANCE specifies the maximum number of migratable open connections globally for each database instance.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
No |
|
Modifiable in a PDB |
No |
|
Range of values |
0 to 231 – 1 |
|
Basic |
No |
|
Oracle RAC |
Multiple instances can have different values. |
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.
See Also:
-
“OPEN_LINKS”
-
Oracle Database
Development Guide for more information about using this parameter in Oracle XA applications
