Re: Shared server tuning

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Wed, 9 Jun 2004 07:03:45 -0700 (PDT)
Message-ID: <20040609140345.64304.qmail@web50606.mail.yahoo.com>

Aaron:
I'm having exactly this problem.
My beloved yapp reports that I've depended upon for the last couple of years now only report 1 thing -- tune MTS. The virtual circuit status waits are so high that nothing else stands out.

I've been round-and-round with Oracle about this. Oracle is absolutely insistent that virtual circuit status is an "idle" event. They have offered no assistance at all. I've been using an mts report from Tim Gorman's web site for a couple of years. Like your system, mine shows little activity for either the dispatchers or the servers.

If dedicated sessions are an option for you, leave shared server (mts) behind in the dust. You'll be much happier.

If you continue to use shared server and ever find any relief, please let me know what you come up with.

Best of luck!
Barb

• "Sentell, Aaron" <aaron_sentell_at_tempe.gov> wrote:
  > 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.
  

  ---

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 09 2004 - 09:00:32 CDT