From oracle-l-bounce@freelists.org Mon Oct 24 21:08:16 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9P28GcE008455 for ; Mon, 24 Oct 2005 21:08:16 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9P28FvX008446 for ; Mon, 24 Oct 2005 21:08:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4BAF920D9BF; Mon, 24 Oct 2005 21:08:12 -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 29630-09; Mon, 24 Oct 2005 21:08:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B5D6920D9C1; Mon, 24 Oct 2005 21:08:11 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=vF1Ihh5Aju4MCTeDA6uIgJLgz07XFYA1JAkiu1qJIYeW01SfzHSEEy1Fw2Bjx1zR7XPxCm67/36w3wgyKD/fJFIC4wFoRtyTwf8X9YKyJpXOjG0dKThwtnucLYDnBg+IjFbOMTca/klhqbg2uefAZ9EKVMtcgWoQXEEo3koVJCs= ; Message-ID: <20051025020614.47382.qmail@web31407.mail.mud.yahoo.com> Date: Mon, 24 Oct 2005 19:06:14 -0700 (PDT) From: raja rao Subject: RE: oracle is causing high WIO To: John Kanagaraj , ganstadba@hotmail.com Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-858344948-1130205974=:43747" X-archive-position: 27490 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: raja4list@yahoo.com Precedence: normal Reply-To: raja4list@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD,HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 --0-858344948-1130205974=:43747 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi Kanagaraj, At last we identified the root cause is the px slaves. When we removed them from the init and bounced the instance, everything became normal. Thanks for the help. However, I will collect all the stuff that is provided by our forum members. Thanks to everyone who helped me for this. Thanks, Raj John Kanagaraj wrote: Raja, Were there any recent changes (on both Oracle and UNIX side)? High WIO could also be caused by heavy swapping (not just paging). Use sar -q to see the swap queue and sar -d to determine which disk (or LUN) is causing this issue... Did you have any memory errors that required a reboot and the Sa just pulled out some memory cards? Could be a lot of things, not necessarily Oracle. John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910 ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** --------------------------------- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of raja rao Sent: Monday, October 24, 2005 9:26 AM To: ganstadba@hotmail.com Cc: oracle-l@freelists.org Subject: Re: oracle is causing high WIO even after the startup restrict also the below is the WIO: $ sar -u 2 5 SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005 12:09:30 %usr %sys %wio %idle 12:09:32 11 6 64 19 12:09:34 12 7 66 16 12:09:36 4 1 90 6 12:09:38 0 0 94 5 12:09:40 0 0 90 10 $ --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. --0-858344948-1130205974=:43747 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi Kanagaraj,
 
At last we identified the root cause is the px slaves. When we removed them from the
init and bounced the instance, everything became normal.
 
Thanks for the help. However, I will collect all the stuff that is provided by our forum members.
 
Thanks to everyone who helped me for this.
 
Thanks,
Raj

John Kanagaraj <john.kanagaraj@hds.com> wrote:
Raja,
 
Were there any recent changes (on both Oracle and UNIX side)? High WIO could also be caused by heavy swapping (not just paging). Use sar -q to see the swap queue and sar -d to determine which disk (or LUN) is causing this issue... Did you have any memory errors that required a reboot and the Sa just pulled out some memory cards? Could be a lot of things, not necessarily Oracle.
 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
 
Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910
 
** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **


From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of raja rao
Sent: Monday, October 24, 2005 9:26 AM
To: ganstadba@hotmail.com
Cc: oracle-l@freelists.org
Subject: Re: oracle is causing high WIO

even after the startup restrict also the below is the WIO:
 
$ sar -u 2 5
SunOS oracle 5.9 Generic_117171-02 sun4u    10/24/2005
12:09:30    %usr    %sys    %wio   %idle
12:09:32      11       6      64      19
12:09:34      12       7      66      16
12:09:36       4       1      90       6
12:09:38       0       0      94       5
12:09:40       0       0      90      10
$


Yahoo! FareChase - Search multiple travel sites in one click. --0-858344948-1130205974=:43747-- -- http://www.freelists.org/webpage/oracle-l