Reg. MTS Connections..
Hi DBAs, I wud like to know the advantages of using MTS connections. While querying V$session, i found the SERVER column showing DEDICATED NONE values for some sessions. What does this mean? and which type of connection is good? Is there any recommendations like which type of application shud use such type of connections. Any doc or ppt avail. in the net ? Thanks in advance. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
mts connections
Hi list, I set up MTS for one of my instance in Sun OS 5.7 Looks like that the setup works fine by issue 'lsnrctl services' command: tsp has 2 service handler(s) DEDICATED SERVER established:6332 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:254 state:ready D000 machine: nnidb1, pid: 5412 (ADDRESS=(PROTOCOL=ipc)(DEV=20)(KEY=#5412.1)) My question is, why no session has ever established through dispather, even though there are 6332 session connected through dedicated services. Is there a threshod for MTS kicks in? TIA Eveleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: mts connections
Hi, That it is because you aren't using a service referencing the dispatcher. F.e. On 8i: in init.ora mts_dispatchers="(protocol=ipc)(dispatchers=1)(service=mtsipc)" And in the tnsnames.ora mtsservice= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =IPC)(KEY=SID or if you use listener.ora, then the ipc alias)) ) (CONNECT_DATA = (service_name= mtsipc)) ) -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de febrero de 2001 18:21 Para: Multiple recipients of list ORACLE-L Asunto: mts connections Hi list, I set up MTS for one of my instance in Sun OS 5.7 Looks like that the setup works fine by issue 'lsnrctl services' command: tsp has 2 service handler(s) DEDICATED SERVER established:6332 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:254 state:ready D000 machine: nnidb1, pid: 5412 (ADDRESS=(PROTOCOL=ipc)(DEV=20)(KEY=#5412.1)) My question is, why no session has ever established through dispather, even though there are 6332 session connected through dedicated services. Is there a threshod for MTS kicks in? TIA Eveleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).