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/01162547956814057472.html">ADSL VPS每天可获得多少独立IP地址? (adsl vps一天多少ip)</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/01162547942196908032.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/01162547923905548288.html">提速到10m,提升网站速度需要注意什么? (服务器带宽1m)</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/01162547904301371392.html">Minecraft服务器版PE发布啦!快来体验优质游戏体验! (服务器版pe)</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/01162547887721287680.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/01162547875117404160.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/01162547860324093952.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/01162547848525516800.html">SQL Server如何新建服务器注册表? (sql server 新建服务器注册表)</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/01162547828204113920.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/01162547808406999040.html">安云服务器:让您的网络环境更稳定、更高效! (安云服务器)</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>