From oracle-l-bounce@freelists.org Tue Jun 8 16:41:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i58Lepn16779 for ; Tue, 8 Jun 2004 16:41:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i58Lef616734 for ; Tue, 8 Jun 2004 16:40:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB54F72CA0A; Tue, 8 Jun 2004 16:26:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22031-78; Tue, 8 Jun 2004 16:26:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A3AC72C5DC; Tue, 8 Jun 2004 16:26:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Jun 2004 16:25:02 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70E6272C39B for ; Tue, 8 Jun 2004 16:25:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22926-15 for ; Tue, 8 Jun 2004 16:25:01 -0500 (EST) Received: from serum.tempe.gov (serum.tempe.gov [164.50.100.252]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id AC15572D236 for ; Tue, 8 Jun 2004 16:25:00 -0500 (EST) Received: from 164.50.100.238 by serum.tempe.gov (InterScan E-Mail VirusWall NT); Tue, 08 Jun 2004 14:44:14 -0700 Received: by mercury.tempe.gov with Internet Mail Service (5.5.2657.72) id ; Tue, 8 Jun 2004 14:44:13 -0700 Message-ID: From: "Sentell, Aaron" To: oracle-l@freelists.org Subject: RE: Shared server tuning Date: Tue, 8 Jun 2004 14:44:13 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2296 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: aaron_sentell@tempe.gov Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, Thomas F Sent: Tuesday, June 08, 2004 12:07 PM To: 'oracle-l@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@tempe.gov] Sent: Tuesday, June 08, 2004 2:48 PM To: oracle-l@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@vtext.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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@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@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 -----------------------------------------------------------------