MTS performance is too bad.
I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin
RE: MTS performance is too bad.
What is your maximum MTS servers? -Original Message-From: Bunyamin Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: MTS performance is too bad. I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin
Re: MTS performance is too bad.
Do consider setting large_pool_size. Here's a script to get you started. MTS has bugs under 8i where the dispatcher hangs, especially when connections use JDBC thin. col name format a10 col network format a40 col status format a14 PROMPT *** MTS DISPATCHER STATISTICS *** select name,owned,status, (busy/(busy + idle)) * 100 % busy from v$dispatcher / PROMPT *** MTS SHARED SERVER STATISTICS *** select name,status,requests, (busy /(busy + idle)) * 100 % busy from v$shared_server / PROMPT *** MTS QUEUE STATUS AND WAITS *** select paddr, type, queued, wait, totalq, decode(totalq,0,0,wait/totalq) AVG WAIT from v$queue / PROMPT *** CURRENT MTS CONNECTIONS *** select s.username, c.dispatcher, c.server, c.status from v$circuit c, v$session s where c.saddr = s.saddr / PROMPT *** MTS STATISTICS *** select maximum_connections max_conn, servers_started, servers_terminated, servers_highwater from v$mts / Bunyamin Karadeniz wrote: I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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 performance is too bad.
Change back to dedicated servers. Jared Bunyamin Karadeniz [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/26/2002 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:MTS performance is too bad. I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin -- 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 performance is too bad.
Everything I have seen from experience tells me to avoid using MTS if you can ! FWIW. Mike -Original Message- Sent: Wednesday, June 26, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Change back to dedicated servers. Jared Bunyamin Karadeniz [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/26/2002 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:MTS performance is too bad. I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin -- 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: Johnson, Michael 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).