Oracle 参数 USE_DEDICATED_BROKER 官方解释,作用,如何配置最优化建议


本站中文解释

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><p> msg.document.write(‘Footnote  ‘ + footnum);<br /> msg.document.write(”);<br /> msg.document.write(”);<br /> msg.document.write(‘ <![CDATA[ ');<br /> msg.document.write('h1 {text-align: center; font-size: 14pt;}');<br /> msg.document.write('fieldset {border: none;}');<br /> msg.document.write('form {text-align: center;}');<br /> msg.document.write(' ]]\u003e ‘);<br /> msg.document.write(‘</p><h1>Footnote  ‘ + footnum + ‘</p><p>‘);<br /> msg.document.write(footnote);<br /> msg.document.write(‘</p><fieldset>‘);<br /> msg.document.write(”);<br /> msg.document.write(”);<br /> msg.document.close();<br /> setTimeout(function() {<br /> var height = msg.document.getElementById(‘footnote’).offsetHeight;<br /> msg.resizeTo(598, height + 100);<br /> }<br /> , 100);<br /> msg.focus();<br />}</p><p>The script content on this page is for navigation purposes only and does not alter the content in any way.</p><p><code class="codeph">USE_DEDICATED_BROKER</code> determines how dedicated servers are spawned. </p><p> </p><table cellpadding="4" cellspacing="0" class="Formal" title="" summary="This table describes the properties for this initialization parameter" width="100%" border="1" rules="rows"><thead><tr align="left" valign="top"><th align="left" valign="bottom" width="25%" id="d224662e123">Property</th><th align="left" valign="bottom" width="75%" id="d224662e126">Description</th></tr></thead><tbody><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e131" headers="d224662e123 "><p><span class="bold">Parameter type</span></p></td><td align="left" valign="top" width="75%" headers="d224662e131 d224662e126 "><p>Boolean</p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e139" headers="d224662e123 "><p><span class="bold">Default value</span></p></td><td align="left" valign="top" width="75%" headers="d224662e139 d224662e126 "><p><code class="codeph">False</code> unless multithreaded Oracle is enabled<sup>Foot 1</sup></p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e158" headers="d224662e123 "><p><span class="bold">Modifiable</span></p></td><td align="left" valign="top" width="75%" headers="d224662e158 d224662e126 "><p><code class="codeph">ALTER SYSTEM</code></p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e167" headers="d224662e123 "><p><span class="bold">Modifiable in a PDB</span></p></td><td align="left" valign="top" width="75%" headers="d224662e167 d224662e126 "><p>No</p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e175" headers="d224662e123 "><p><span class="bold">Range of values</span></p></td><td align="left" valign="top" width="75%" headers="d224662e175 d224662e126 "><p><code class="codeph">true | false</code></p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e184" headers="d224662e123 "><p><span class="bold">Basic</span></p></td><td align="left" valign="top" width="75%" headers="d224662e184 d224662e126 "><p>No</p></td></tr><tr align="left" valign="top"><td align="left" valign="top" width="25%" id="d224662e192" headers="d224662e123 "><p><span class="bold">Oracle RAC</span></p></td><td align="left" valign="top" width="75%" headers="d224662e192 d224662e126 "><p>If specified, all instances must use the same value</p></td></tr></tbody></table><p> </p><p class="tablefootnote"><sup class="tablefootnote">Footnote 1 </sup></p><p>Multithreaded Oracle is enabled by setting the <code class="codeph">THREADED_EXECUTION</code> initialization parameter to <code class="codeph">true</code>. </p><p>When this parameter is set to <code class="codeph">false</code>, the listener spawns a dedicated server directly. </p><p>When this parameter is set to <code class="codeph">true</code>, 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. </p><p>To enable the dedicated connection broker using the <code class="codeph">USE_DEDICATED_BROKER</code> initialization parameter, you must: </p><ol><li><p>Set the <code class="codeph">USE_DEDICATED_BROKER</code> initialization parameter to <code class="codeph">true</code>. </p></li><li><p>Set the <code class="codeph">DEDICATED_THROUGH_BROKER_</code><span class="italic">listener-name</span> parameter to <code class="codeph">on</code> in the listener.ora file. </p></li></ol><p>Performing these two steps configures the Connection Broker Process (N<span class="italic">nnn</span>). </p><p class="notep1">Note:</p><p>When multithreaded Oracle is enabled, the dedicated connection broker process is also enabled and used.</p></p><p>Configuration of the brokers is controlled by the <code class="codeph">CONNECTION_BROKERS</code> initialization parameter. </p><p class="notep1">See Also:</p><ul style="list-style-type: disc"><li><p><span class="q">“CONNECTION_BROKERS”</span> for more information about configuring brokers </p></li><li><p>Table F-1 for more information about the Connection Broker Process (N<span class="italic">nnn</span>) </p></li><li><p><span class="q">“THREADED_EXECUTION”</span> for more information about enabling multithreaded Oracle </p></li><li><p><span><cite>Oracle Database Net<br /> Services Reference</cite></span> for more information about the <code class="codeph">DEDICATED_THROUGH_BROKER_</code><span class="italic">listener-name</span> parameter in the listener.ora file </p></li></ul></p><p> </div> </div> </div> <div class="main-news"> <div class="layui-container"> <div class="layui-row layui-col-space20"> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366912257200128.html">走进虚拟主机的世界:了解不限内容的选择 (不限内容虚拟主机)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366900760612864.html">如何实现域名与VPS之间的绑定关系 (域名和vps怎么绑定)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366888546799616.html">如何优化主机服务器配置? (主机服务器配置)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366848847712256.html">如何全面测试阿里云服务器性能达到更佳配置? (如何测试阿里云服务器配置)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366828505337856.html">天价主机:电脑硬件价格飙升,你的新装机计划受影响了吗? (天价主机)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366815763042304.html">局域网云服务器:实现快速便捷的服务器部署和管理 (局域网云服务器)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366802437738496.html">阿里云备案抽检 官方通知:提醒用户及时备案 避免网站被封 (阿里云 备案 抽检)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366783873748992.html">虚拟主机网站设计技巧大揭秘! (虚拟主机怎么设计网站吗)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366771198562304.html">服务器扩展存储——多块盘子挂载方法简介 (一个服务器能挂载多块盘子)</a> </div> </div> <div class="layui-col-lg6 content"> <div class="news-panel" style="padding-bottom:3px;width: auto"> <a href="http://www.zmcms.com/news/01162366752311611392.html">购买100元虚拟主机,建立你的在线平台 (100元虚拟主机)</a> </div> </div> </div> </div> </div> <div class="footer"> <div class="layui-container"> <p class="footer-web"> </p> <div class="layui-row footer-contact"> <div class="layui-col-sm2 layui-col-lg1"><img width="90" height="90" src="https://global.cnd.aidufei.com/24114879/template/1323677109394214912.png"></div> <div class="layui-col-sm10 layui-col-lg11"> <div class="layui-row"> <div class="layui-col-sm6 layui-col-md8 layui-col-lg9"> <p class="contact-top"><i class="layui-icon layui-icon-cellphone"></i> 13432074335 (9:00-18:00)</p> <p class="contact-bottom"><i class="layui-icon layui-icon-home"></i> qp@qiping.cn</p> </div> <div class="layui-col-sm6 layui-col-md4 layui-col-lg3"> <p class="contact-top"><span class="right">© 祺平科技 • 版权所有</span></p> <p class="contact-bottom"><span class="right"> <a href="https://beian.miit.gov.cn" target="_blank">粤ICP备15012827号</a><br> <a href="https://zmcms.com" target="_blank">ZMCMS.COM</a> </span></p> </div> </div> </div> </div> </div> </div> <script src="https://global.cnd.aidufei.com/cms/lib/layui/layui.js"></script> <script>var path ='https://global.cnd.aidufei.com/cms/';var template ='t0_2';layui.config({base:path+'web/'+template+'/js/' }).use('firm');</script><script>proxyImage('.introTop');adjustImageSize('.introTop');$(window).resize(function() {adjustImageSize('.introTop');});</script> <script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script> <script>LA.init({id:"3KldQ01GV5xj4Rgb",ck:"3KldQ01GV5xj4Rgb"})</script> </body> </html>