Initialization Parameters, 118 of 188

OPEN_LINKS

Parameter type:
Integer

Parameter class:
Static

Default value:
4

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 the schema objects called database links, as well as external procedures and cartridges, each of which uses a separate process.
Oracle counts one open link

For each user that references a public or private database link and

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 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.
See Also: "OPEN_LINKS_PER_INSTANCE" for information on setting open connections globally for a database instance.

Parameter type:	Integer
Parameter class:	Static
Default value:	4
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 the schema objects called database links, as well as external procedures and cartridges, each of which uses a separate process. Oracle counts one open link For each user that references a public or private database link and 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 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. See Also: "OPEN_LINKS_PER_INSTANCE" for information on setting open connections globally for a database instance.