Oracle修改dblink连接数
来源:互联网 发布:西门子plc200编程实例 编辑:程序博客网 时间:2024/05/16 08:41
alter system set open_links=10 scope=spfile;alter system set open_links_per_instance=10 scope=spfile;
OPEN_LINKS
4
ModifiableNoRange of values0 to 255OPEN_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 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.
OPEN_LINKS_PER_INSTANCE
4
ModifiableNoRange of values0 to 4294967295 (4 GB -1)Oracle RACMultiple 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.
- Oracle修改dblink连接数
- 修改Oracle连接数
- oracle 修改连接数
- 修改Oracle连接数
- 修改oracle连接数、oracle、连接数
- Oracle DBLink连接数过多的问题(Ora-02020)
- Oracle dblink 连接
- 修改oracle最大连接数
- 修改Oracle最大连接数
- 修改Oracle最大连接数
- 修改Oracle最大连接数
- oracle修改最大连接数
- 修改Oracle最大连接数
- 修改 Oracle最大连接数
- oracle修改最大连接数
- 修改Oracle最大连接数
- Oracle查看、修改连接数
- 修改Oracle最大连接数
- Js DOM 基本
- 20款Notepad++插件
- Bat语法
- RED5-0.9.1Final流媒体服务器安装(一)
- ActiveMQ的N多问题
- Oracle修改dblink连接数
- 2个工厂间的转储
- redhat5.4下安装jdk和tomcat
- MySQL Workbench 中文使用教程(一)
- ExtJS grid一些属性说明
- cvGaussBGModel
- 后缀数组,多线程
- 进程的状态转换
- C#映射网络驱动器