From oracle-l-bounce@freelists.org Mon Oct 24 13:01:44 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9OI1ipi021207 for ; Mon, 24 Oct 2005 13:01:44 -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 j9OI1evX021190 for ; Mon, 24 Oct 2005 13:01:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D89820CEFD; Mon, 24 Oct 2005 13:01:37 -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 10372-05; Mon, 24 Oct 2005 13:01:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 233AF20A740; Mon, 24 Oct 2005 13:01:37 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:cc:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=g+uHWrWt/AMoSQcQnVU5xoG9/SugiIzRmOSU45Wbo/GC3af0VOtUPQWmVTSS5yRcTtBEUZJPQs+R0neHCS/H9HvXlGbldWeZYg9za1VutzRcXkNBU6qCb5pB/TccneG3s3NAQGKGQXS1W0A6FEEtlh8VT21sg3KOqFDjRACRV9U= Message-ID: <008501c5d8c4$b57042b0$3508310a@IBME1D11967173> From: "Radoulov, Dimitre" To: Cc: References: <20051024162535.66390.qmail@web31408.mail.mud.yahoo.com> Subject: Re: oracle is causing high WIO Date: Mon, 24 Oct 2005 19:59:33 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C5D8D5.73D575D0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-archive-position: 27465 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.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=-4.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_0082_01C5D8D5.73D575D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Try prstat -m and check the major contributors for the % of SYS mode. I = *think* the kernel mode includes the IO device wait time. /app/oracle$ prstat -m PID USERNAME USR SYS TRP TFL DFL LCK SLP LAT VCX ICX SCL SIG = PROCESS/NLWP =20 11603 oracle 56 3.3 0.0 0.0 0.0 0.0 39 1.3 1K 73 1K 0 oracle/1 24601 oracle 11 3.6 0.0 0.0 0.0 0.0 86 0.0 160 17 6K 0 oracle/1 24599 oracle 6.2 4.1 0.0 0.0 0.0 0.0 90 0.0 138 5 5K 0 oracle/1 HTH, Dimitre=20 ------=_NextPart_000_0082_01C5D8D5.73D575D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Try prstat -m and check = the major=20 contributors for the % of SYS mode. I *think* the kernel mode = includes the=20 IO device wait time.

/app/oracle$ prstat = -m
   PID=20 USERNAME USR SYS TRP TFL DFL LCK SLP LAT VCX ICX SCL SIG = PROCESS/NLWP =20
11603 oracle    56 3.3 0.0 0.0 0.0 0.0 39 = 1.3 1K 73 1K   0 oracle/1
24601=20 oracle    11 3.6 0.0 0.0 0.0 0.0 86 0.0 160 = 17 =20 6K   0 oracle/1
24599 oracle   6.2 4.1 0.0 = 0.0 0.0=20 0.0 90 0.0 138   5 5K   0 = oracle/1

HTH,
Dimitre

------=_NextPart_000_0082_01C5D8D5.73D575D0-- -- http://www.freelists.org/webpage/oracle-l