• oralce MTS


    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

  • 相关阅读:
    [转]权限管理模型
    如何解决 “invalid resource directory name”, resource “crunch”
    Oracle ERP Interface堵住--Request Running too long time,查找Request执行的Sql
    【转】令人印象深刻的廣告詞
    【异常】SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource
    你是喜欢一个人本身,还是
    关于Oracle 的安装记(不定期更新)
    kafka
    mysql去除换行和空格
    mysql 字段值拼接,同一字段循环拼接
  • 原文地址:https://www.cnblogs.com/fanweisheng/p/11113462.html
Copyright © 2020-2023  润新知