Re: Re: Re:MTS performance is too bad.
I decreased hash_area_size , I setted large_pool_size . I decreased dispatcher number to 4. And everything is well now. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 1:18 PM How did you solved it? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 4:03 PM FINALLY , Everything is good now. Thank you for your replies. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 12:33 AM I suspect that if you are getting 4030s with 50 concurrent users that you will get NO benefit from MTS, in fact it will likely cause just the problems you are seeing and you will start to get 4030s sooner than you would have before. MTS is not appropriate as a tool to address your 4030 errors if the sessions are not inactive for more than a few seconds. If the concurrent sessions are very active (check v$session's last_call_et field) and you are still running into 4030s than MTS will not help you, and can actually cause a performance hit (CPU) that is scary. The key thing to remember is that MTS provides SCALABILITY, performance is indirectly affected if at all. If you are running into 4030s there are a number of other approaches you can take as well. Application tuning is the best place to start, but more often then not, not possible. Then go to the obvious (that others have mentioned) like using statspack to get a look at the usage of your buffer cache. In your case you may have to reduce the size of your SGA to allow for more user space. Don't fall for the buffer cache hit ratio needs to be x%. If you are in an application env where most blocks are rarely seen in more than one query then you need a different approach to buffer cache tuning than hit %. This is a book in and of itself, but fairly intuitive. Given that you are stuck with your current application, the very first thing you also will want to look at is the Orastack utility to reduce the memory usage of each server process' stack. I have seen DBAs in your situation have their 4030s resolved with this alone. The other is upgrading your OS (or properly setting it) to NT EE or Win2k AS. This will allow you to use a 3gb process size. If you haven't done this it will surely fix your memory shortage (at least until you get another 50 users :)). You can also scale out by adding more nodes with OPS, although I'd strongly suggest that you move to 9i before doing this! Finally, you can use OPS/RAC on a single box, a bit of a fancy trick, but it allows you to have multiple instances if you have the system memory available. Ramble, ramble, ramble, for more info you can come to my presenation at OpenWorld (or just send more info/questions!) Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Karadeniz Sent: Thursday, June 27, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool
Re: Re: Re:MTS performance is too bad.
How did you solved it? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 4:03 PM FINALLY , Everything is good now. Thank you for your replies. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 12:33 AM I suspect that if you are getting 4030s with 50 concurrent users that you will get NO benefit from MTS, in fact it will likely cause just the problems you are seeing and you will start to get 4030s sooner than you would have before. MTS is not appropriate as a tool to address your 4030 errors if the sessions are not inactive for more than a few seconds. If the concurrent sessions are very active (check v$session's last_call_et field) and you are still running into 4030s than MTS will not help you, and can actually cause a performance hit (CPU) that is scary. The key thing to remember is that MTS provides SCALABILITY, performance is indirectly affected if at all. If you are running into 4030s there are a number of other approaches you can take as well. Application tuning is the best place to start, but more often then not, not possible. Then go to the obvious (that others have mentioned) like using statspack to get a look at the usage of your buffer cache. In your case you may have to reduce the size of your SGA to allow for more user space. Don't fall for the buffer cache hit ratio needs to be x%. If you are in an application env where most blocks are rarely seen in more than one query then you need a different approach to buffer cache tuning than hit %. This is a book in and of itself, but fairly intuitive. Given that you are stuck with your current application, the very first thing you also will want to look at is the Orastack utility to reduce the memory usage of each server process' stack. I have seen DBAs in your situation have their 4030s resolved with this alone. The other is upgrading your OS (or properly setting it) to NT EE or Win2k AS. This will allow you to use a 3gb process size. If you haven't done this it will surely fix your memory shortage (at least until you get another 50 users :)). You can also scale out by adding more nodes with OPS, although I'd strongly suggest that you move to 9i before doing this! Finally, you can use OPS/RAC on a single box, a bit of a fancy trick, but it allows you to have multiple instances if you have the system memory available. Ramble, ramble, ramble, for more info you can come to my presenation at OpenWorld (or just send more info/questions!) Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Karadeniz Sent: Thursday, June 27, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale
Re: Re: Re:MTS performance is too bad.
FINALLY , Everything is good now. Thank you for your replies. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 28, 2002 12:33 AM I suspect that if you are getting 4030s with 50 concurrent users that you will get NO benefit from MTS, in fact it will likely cause just the problems you are seeing and you will start to get 4030s sooner than you would have before. MTS is not appropriate as a tool to address your 4030 errors if the sessions are not inactive for more than a few seconds. If the concurrent sessions are very active (check v$session's last_call_et field) and you are still running into 4030s than MTS will not help you, and can actually cause a performance hit (CPU) that is scary. The key thing to remember is that MTS provides SCALABILITY, performance is indirectly affected if at all. If you are running into 4030s there are a number of other approaches you can take as well. Application tuning is the best place to start, but more often then not, not possible. Then go to the obvious (that others have mentioned) like using statspack to get a look at the usage of your buffer cache. In your case you may have to reduce the size of your SGA to allow for more user space. Don't fall for the buffer cache hit ratio needs to be x%. If you are in an application env where most blocks are rarely seen in more than one query then you need a different approach to buffer cache tuning than hit %. This is a book in and of itself, but fairly intuitive. Given that you are stuck with your current application, the very first thing you also will want to look at is the Orastack utility to reduce the memory usage of each server process' stack. I have seen DBAs in your situation have their 4030s resolved with this alone. The other is upgrading your OS (or properly setting it) to NT EE or Win2k AS. This will allow you to use a 3gb process size. If you haven't done this it will surely fix your memory shortage (at least until you get another 50 users :)). You can also scale out by adding more nodes with OPS, although I'd strongly suggest that you move to 9i before doing this! Finally, you can use OPS/RAC on a single box, a bit of a fancy trick, but it allows you to have multiple instances if you have the system memory available. Ramble, ramble, ramble, for more info you can come to my presenation at OpenWorld (or just send more info/questions!) Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Karadeniz Sent: Thursday, June 27, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin,
Re: Re:MTS performance is too bad.
mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- 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: Bunyamin Karadeniz 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: Re:MTS performance is too bad.
Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- 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: Bunyamin Karadeniz 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Re:MTS performance is too bad.
I agree with you but that will not help me in performance ... Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 12:28 PM Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- 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: Bunyamin Karadeniz 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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
Re: Re: Re:MTS performance is too bad.
You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 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. nbsp; What can I do ?nbsp; Have you got an idea. How can I check the mts performance? nbsp; 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: Bunyamin Karadeniz 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: MICHAEL.SALE 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: Re:MTS performance is too bad.
Hello Bunyamin I seem to miss something here. If you have up to 50 concurrent users why do you use min_servers =100? I think that you waste a lot of storage this way and this can cause the computer to page a lot. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 1:38 PM I agree with you but that will not help me in performance ... Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 12:28 PM Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- 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: Bunyamin Karadeniz 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: Re:MTS performance is too bad.
Well yes it will as you will not have the overhead of managing all of those unnecessary processes. However, as Michael Sale has correctly pointed out, you don't need MTS for 50 connections. -Original Message- Sent: 27 June 2002 12:38 To: Multiple recipients of list ORACLE-L I agree with you but that will not help me in performance ... Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 12:28 PM Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- 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: Bunyamin Karadeniz 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Re: Re:MTS performance is too bad.
Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 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. nbsp; What can I do ?nbsp; Have you got an idea. How can I check the mts performance? nbsp; 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: Bunyamin Karadeniz 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: MICHAEL.SALE 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
Re[2]: Re: Re:MTS performance is too bad.
What you get when you read messages in reverse chronological order!! OK, if you've got memory problems, start with trying to address those first. Can you decrease the size of the SGA? Cut the DB_BLOCK_BUFFERS back by a third is possible, limit the shared_pool if you can,and get more memory again if possible. Oracle is one heck of a memory hog, no matter what platform your on. Assuming all of that fails to resolve the ORA-4030 errors in dedicated server mode, then I guess your stuck with going MTS. Rules of thumb that Oracle handed me is fixing an iTAR: 1) set up one dispatcher for every 50 to 500 connections you expect. Practice here says experiment around a bit. The capacity of a dispatcher is a variable on each platform. HP is not exactly happy with more than 52 per dispatcher. 2) For every dispatcher there is, have a minimum of 2 shared servers. If you've got 2 dispatchers, which is just about the bottom of the barrel you need a minimum of 4 shared servers. 3) for every shared server, allocate 100K additional shared pool. This gets tricky since changing the shared pool means bouncing the database. I read it as MTS_MAX_SERVERS*100K added to the shared_pool. 4) last watch the utilization of your shared servers. If they all remain busy more than 50% of the time, up the value os MTS_MIN_SERVERS either in the init.ora and bounce or via the alter system command. 5) Continue to use decidated servers for all batch load/DML activities. Leave the MTS stuff for OLTP types of transactions. 6) And after all this, don't really expect an increase in performance, cause you ain't going to get it. Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/27/2002 6:33 AM Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 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. nbsp; What can I do ?nbsp; Have you got an idea. How can I check the mts performance? nbsp; Bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Re: Re:MTS performance is too bad.
So far, I did not see what is the specific performance problem here. I support one of the five warehouses that has over 300 users and we implemented dedicated servers but we ended up with heavy disk swap because application had external call procedure which gets Unix timestamp from Oracle. This resulted in holding/ never releasing the Unix processes. So we switched to MTS and requested application to use Oracle timestamp instead. Our MTS parameters: mts_servers=4 Start up 4 servers dispatcher=10 mts_max_servers=20 shared pool=360mb Performance is as good as dedicated servers. I implemented on all other four warehouses. Our MTS has been running for over 8 months now. -Original Message- Sent: Thursday, June 27, 2002 7:33 AM To: Multiple recipients of list ORACLE-L Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 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. nbsp; What can I do ?nbsp; Have you got an idea. How can I check the mts performance? nbsp; 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: Bunyamin Karadeniz 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:
RE: Re: Re:MTS performance is too bad.
Bunyamin: Is performance bad overall, or just for a few sessions? If you have not done so, get the mts script from Tim Gorman's web site (www.evdbt.com). In particular, run the section on active circuit statistics. This should return no rows. If it returns rows, you're in trouble. Track back those sessions (with the session id/serial#) and see what they're up to. Do you have large pool configured? If not, I'd suggest you do so. Good luck! Barb (Tim's active circuit stats portion of mts script:) prompt prompt MTS Active Circuit Statistics: select c.circuit, to_char(s.sid) || ',' || to_char(s.serial#) sid, d.name dispatcher, ss.name server, substr(c.queue,1,8) queue, c.waiter fromv$circuit c, v$session s, v$dispatcherd, v$shared_server ss where s.saddr = c.saddr and d.paddr = c.dispatcher and ss.paddr = c.server / -- From: Bunyamin Karadeniz[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: Re:MTS performance is too bad. Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:53 PM You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. That said, your MTS config is WAY out of whack given the number of concurrent users: You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book Oracle9i for Windows 2000 Tips Techniques. It covers the setup, monitoring and basic tuning of MTS. I hope this helps, Mike Sale mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM 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 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. nbsp; What can I do ?nbsp; Have you got an idea. How can I check the mts performance? nbsp; 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
