首页 > 其他 > 详细

oralce MTS

时间:2019-07-01 14:11:16      阅读:99      评论:0      收藏:0      [点我收藏+]

MTS的组件包括:

processes on the system、

communication software、

the shared global section (SGA).

 

             SQL*Net                 SGA               SGA
 ----------          --------------       -----------       ----------
 | Client |<-------->| Dispatcher |<----->| Circuit |<----->| Shared |
 ----------          --------------       -----------       | Server |
                                               |            ----------
  ‘JSMITH‘          ‘ORA_<sid>_D000‘           |         ‘ORA_<sid>_S000‘
                                          +---------+
                                          | Session |
                                          +---------+

 

复杂版本:

          SQL*Net(监听器)             SGA               SGA
 ----------          --------------       -----------       ----------
 | Client |<-------->| Dispatcher |<----->| Circuit |<----->| Shared |
 ----------          --------------       -----------       | Server |
                                               |            ----------
  ‘JSMITH‘          ‘ORA_<sid>_D000‘           |         ‘ORA_<sid>_S000‘
                                          +---------+
                                          | Session |
                                          +---------+

 

Some views containing MTS information include:

V$CIRCUIT

控制为一个输入和输出网络会话所预测的虚拟电路的总数量。

V$SHARED_SERVER

 

V$DISPATCHER

V$MTS

V$QUEUE

V$SESSION

 

Dispatcher的数量从mts_dispatchers(init.ora)到MTS_MAX_DISPATCHERS

oralce MTS

原文:https://www.cnblogs.com/fanweisheng/p/11113462.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!