FAQ
Something else to look for could be, and I say could be, the infamous Oracle
Trace stuff working for connections. Tom: Do you remember this issue where
connection time significantly increased as a file got larger. Check your
ORACLE_HOME/trace/admin directory and see if you have any files of size in
there. If so, delete them.

Thank You

Stephen P. Karniotis
Compuware Corporation
Direct: (313) 227-4350
Toll Free: (800) 462-7740 ext. 74350

Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Mercadante, Thomas F
Sent: Tuesday, June 08, 2004 3:07 PM
To: 'oracle-l_at_freelists.org'
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
Sent: Tuesday, June 08, 2004 2:48 PM
To: oracle-l_at_freelists.org
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_at_vtext.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
-----------------------------------------------------------------
----------------------------------------------------------------
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

The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 10 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 8, '04 at 1:45p
activeJun 9, '04 at 7:52p
posts10
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase