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