| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared server tuning
Steve, that sounds like the Oracle trace facility problem which I believe
was limited to the first release of the product (? 7.3, 8.0 ?). But if it
were the problem you can expect to find a couple of large (> 5M).dat files
in the $ORACLE_HOME/otrace/admin directory if my memory is correct. I think
it was also possible to generate a large .dat file that slowed connections
down via the listener. I would expect that .dat file to be in the same
directory as the tnsnames.ora and listener.ora files.
But it has been a long time.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Karniotis, Stephen
Sent: Tuesday, June 08, 2004 3:25 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Shared server tuning
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 [mailto: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 [mailto:aaron_sentell_at_tempe.gov]
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |