open_links_per_instance 和 open_links 参数说明

1.1  OPEN_LINKS

Property	Description
Parameter type	Integer
Default value	4
Modifiable	No --即修改需要重启实例
Range of values	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 link

       For each external procedure or cartridge connection when it is executed for the first time

 

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