本站中文解释

USE_DEDICATED_BROKER参数是Oracle数据库10g中引入的新参数，用于控制是否使用专用代理，用于在数据库中进行远程调用程序。在数据库通信连接之间，USE_DEDICATED_BROKER可以控制多个客户端在同一时间连接到同一实例的数据库时是否使用专门的代理，而不是使用数据库中的可用进程：

设置USE_DEDICATED_BROKER应考虑性能和安全性的收益：

USE_DEDICATED_BROKER的可能值如下：

TRUE：表示总是使用专用代理来处理远程调用程序，以保证安全性；
FALSE：表示在数据库忙碌时，使用可用进程处理远程调用程序，以提高性能；
AUTO：表示在客户端发起远程调用程序时，根据数据库是否忙碌自动决定是否使用专用代理。

正确的设置可以根据当前的需求进行调整，最佳设置是AUTO，遵循安全优先

官方英文解释

window.name=’USE_DEDICATED_BROKER’
function footdisplay(footnum,footnote) {
var msg = window.open(‘about:blank’, ‘NewWindow’ + footnum,
‘directories=no,height=100,location=no,menubar=no,resizable=yes,’ +
‘scrollbars=yes,status=no,toolbar=no,width=598’);
msg.document.open(‘text/html’);
msg.document.write(”);
msg.document.write(‘‘);</p>

msg.document.write(‘Footnote  ‘ + footnum);
msg.document.write(”);
msg.document.write(”);
msg.document.write(‘ <![CDATA[ ‘);
msg.document.write(‘h1 {text-align: center; font-size: 14pt;}’);
msg.document.write(‘fieldset {border: none;}’);
msg.document.write(‘form {text-align: center;}’);
msg.document.write(‘ ]]\u003e ‘);
msg.document.write(‘

Footnote  ‘ + footnum + ‘

‘);
msg.document.write(footnote);
msg.document.write(‘

‘);
msg.document.write(”);
msg.document.write(”);
msg.document.close();
setTimeout(function() {
var height = msg.document.getElementById(‘footnote’).offsetHeight;
msg.resizeTo(598, height + 100);
}
, 100);
msg.focus();
}

The script content on this page is for navigation purposes only and does not alter the content in any way.

USE_DEDICATED_BROKER determines how dedicated servers are spawned.

Property	Description
Parameter type	Boolean
Default value	False unless multithreaded Oracle is enabledFoot 1
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Range of values	true | false
Basic	No
Oracle RAC	If specified, all instances must use the same value

^Footnote 1

Multithreaded Oracle is enabled by setting the THREADED_EXECUTION initialization parameter to true.

When this parameter is set to false, the listener spawns a dedicated server directly.

When this parameter is set to true, the listener hands the connection to a dedicated connection broker that spawns the dedicated server. Unlike the listener, the dedicated connection broker is a database process, and hence it can implement policies leveraging database information before the spawn.

To enable the dedicated connection broker using the USE_DEDICATED_BROKER initialization parameter, you must:

1. Set the USE_DEDICATED_BROKER initialization parameter to true.

2. Set the DEDICATED_THROUGH_BROKER_listener-name parameter to on in the listener.ora file.

Performing these two steps configures the Connection Broker Process (Nnnn).

Note:

When multithreaded Oracle is enabled, the dedicated connection broker process is also enabled and used.

Configuration of the brokers is controlled by the CONNECTION_BROKERS initialization parameter.

See Also:

• “CONNECTION_BROKERS” for more information about configuring brokers

• Table F-1 for more information about the Connection Broker Process (Nnnn)

• “THREADED_EXECUTION” for more information about enabling multithreaded Oracle

• Oracle Database Net
  Services Reference for more information about the DEDICATED_THROUGH_BROKER_listener-name parameter in the listener.ora file

Oracle优化 oracle内部视图 oracle参数 oracle开发 oracle故障处理 oracle教程 oracle维护

数据运维技术 » Oracle 参数 USE_DEDICATED_BROKER 官方解释，作用，如何配置最优化建议
分享到：