RE: Shared server tuning

  • From: "Sentell, Aaron" <aaron_sentell@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 8 Jun 2004 14:44:13 -0700

At the most I would say we would be serving 30 concurrent users. Until I
attended IOUG Live in Toronto, I had always thought that MTS was the way to
go. After all, it simplifies things, right? No! From what I learned in
Toronto, I am going to do my best to avoid MTS from now on if I do not
absolutely need it. I am going to look into configuring this instance to use
dedicated connections.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mercadante, Thomas F
Sent: Tuesday, June 08, 2004 12:07 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Shared server tuning

Aaron,

You can get the 90% performance gain if you are not experiencing a known MTS
bug that exists in 8.1.7.2.  Since you are using 9.0.1.3, I suspect that you
may be sharing the same pleasure I am.

The MTS bug causes a 60 second delay in processing.  Something about a
timeout.  I don't get it every time, but we had to work things around a bhit
to avoid it.

Look in Metalink for MTS bugs for your release.

If you can switch to dedicated servers, do it.  How many concurrent users do
you expect to serve?

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Sentell, Aaron [mailto:aaron_sentell@xxxxxxxxx] 
Sent: Tuesday, June 08, 2004 2:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Shared server tuning


I have a six-month-old Oracle 9.0.1.3 database that is using shared server
connections. Users are complaining about system slowness sporadically
throughout the day, but I don't see any CPU, i/o, or network-related issues
with the server itself. I have run a few Statspack reports through
oraperf.com, and they all say that I can get a 90%+ gain by tuning MTS. In
addition, in the waits section, virtual circuit status is by far the event
with the most wait time.

I have checked the v$shared_server_monitor view, and nothing raises a flag
with me. SERVERS_HIGHWATER has never come close to approaching
MAX_SHARED_SERVERS. There are some servers started and terminated throughout
the business day (3-4), but I don't think this would causes the symptoms I
am seeing.

Personally, I am tempted to switch to using dedicated connections. Our
Peoplesoft Financials and HR databases use this, so I doubt this application
would have a problem with it.

Does anybody have any thoughts or ideas? 

Thanks,

Aaron Sentell
Database Administrator
City of Tempe, Arizona
-------------------------------------
Office: (480) 350-8468
Pager: TempeDBA@xxxxxxxxx <mailto:TempeDBA@xxxxxxxxx> 


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: