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/01155812745237630976.html">申请MSSQL空间,提升数据存储水平(空间申请 mssql)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812712551419904.html">连接Redis的简单工具:一步到位(连接redis 的工具)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812685590433792.html">Metasploit破解MSSQL: 开启你的网络攻击之旅!(msf连接mssql)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812663683584000.html">SqlServer中众数的查询与分析(sqlserver 众数)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812623988690944.html">MS SQL数据修复:从零开始(mssql 数据修改)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812601268146176.html">新SQL Server 2017改变数据管理的一切!(sqlserver17)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812562655383552.html">拥抱微软开启MSSQL大门(开启mssql)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812530266968064.html">展现MSSQL使用方式之精彩(mssql使用方式)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812508645330944.html">优雅地使用MSSQL——让你轻松管理数据库(mssql的使用)</a></div></div> <div class="layui-col-lg6 content"><div class="news-panel" style="padding-bottom:3px;width:auto"><a href="/news/01155812482577731584.html">深入了解mssql数据库:查看它的精彩内容(查看mssql数据库内容)</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>