oracle open_link,open_links_per_instance 和 open_links 参数说明

一.先看官网的说明

1.1OPEN_LINKS

Property

https://www.cndba.cn/cndba/dave/article/1431

Description

Parameter type

Integer

Default value

4

Modifiable

No --即修改需要重启实例

Range of valueshttps://www.cndba.cn/cndba/dave/article/1431

0 to 255

OPEN_LINKS specifies the maximum number of concurrent open connections to remote databases in one session. These connections include database links, as well as external procedures and cartridges, each of which uses a separate process.

Oracle counts one open link for the following:

For each user that references a public or private database linkhttps://www.cndba.cn/cndba/dave/article/1431

For each external procedure or cartridge connection when it is executed for the first timehttps://www.cndba.cn/cndba/dave/article/1431

Both types of connections close when the session ends.You can also close a database link connection explicitly by issuing an ALTER SESSION CLOSE DATABASE LINK statement.

You should set this parameter to allow for the external procedure and cartridge connections expected during the session plus the number of databases referred to in typical distributed transactions (that is, a single SQL statement that references multiple databases), so that all the databases can be open to execute the statement.

For example, if queries alternately access databases A, B, and C, and OPEN_LINKS is set to 2, time will be lost waiting while one connection is broken and another made. Increase the value if many different databases are accessed over time.

This parameter refers only to connections used for distributed transactions.Direct connections to a remote database specified as an application connects are not counted.

If you set OPEN_LINKS to 0, then no distributed transactions are allowed.

1.2 OPEN_LINKS_PER_INSTANCE

Property

Description

Parameter type

Integer

Default value

4

Modifiable

No

Range of values

0 to 4294967295 (4 GB -1)

Oracle RAC

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.

二.查看并修改

2.1查看

SQL> show parameter open

NAMETYPEVALUE

------------------------------------ ----------- ------------------------------

open_cursorsinteger300

open_linksinteger4

open_links_per_instanceinteger4

session_max_open_filesinteger10

2.2与这个参数有关的错误是ORA-02020

ORA-02020:too many database links in use

Cause:The current session has exceeded the INIT.ORA open_links maximum.

Action:Increase the open_links limit, or free up some open links by committing or rolling back the transaction and canceling open cursors that reference remote databases.

2.3修改该参数

之前说过， 修改这个参数需要重启实例。可以只修改spfile里的值。 如：

SQL> alter system set open_links=10;

https://www.cndba.cn/cndba/dave/article/1431

alter system set open_links=10

https://www.cndba.cn/cndba/dave/article/1431

*

第1行出现错误:

ORA-02095:无法修改指定的初始化参数

SQL> alter system set open_links=10 scope=spfile;

系统已更改。

在次查看：

SQL> show parameter open_links

NAMETYPEVALUE

------------------------------------ ----------- -------

open_links_per_instanceinteger4

https://www.cndba.cn/cndba/dave/article/1431

------------------------------------------------------------------------------

Blog：http://blog.csdn.net/tianlesoftware

网上资源：http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1群：62697716(满); DBA2群：62697977(满)

DBA3群：62697850DBA超级群：63306533;

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g