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="/news/01160936181085638656.html">Linux应用布署的步骤和方法 (linux怎么布应用)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936171451322368.html">Linux静态IP设置问题解决方法 (linux设置静态ip后无法上网)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936152304324608.html">Linux 终端软件——推动科技进步的力量(linux 终端 软件)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936134096850944.html">Linux文件替换命令:字符轻松应对! (linux文件替换命令字符)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936114249404416.html">Linux下IE浏览器的使用指南 (linux ie)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936100622110720.html">Linux命令大全:快速掌握Shell在Linux中的运行技巧 (shell运行linux命令大全)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936075716333568.html">深入了解Linux操作系统:掌握passwd命令的使用技巧 (linux passwd命令详解)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936060285489152.html">Linux下重新编译安装Apache服务器 (linux 重新编译安装apache)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936038735155200.html">Linux内存消耗状况解析 (linux内存的消耗状态)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01160936019567185920.html">Linux下的密码抓取技术 (linux 密码抓取)</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://www.zmcms.com" target="_blank">www.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/",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>