Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 9855 invoked from network); 9 Sep 2006 02:41:22 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 9 Sep 2006 02:41:22 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FAC840C0BE;
 Sat,  9 Sep 2006 03:40:54 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 14004-02; Sat, 9 Sep 2006 03:40:54 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F003540C0BD;
 Sat,  9 Sep 2006 03:40:53 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 09 Sep 2006 03:15:43 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4374640BA9B
 for <oracle-l@freelists.org>; Sat,  9 Sep 2006 03:15:43 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 09822-01 for <oracle-l@freelists.org>;
 Sat, 9 Sep 2006 03:15:43 -0400 (EDT)
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFF4040B7F9
 for <oracle-l@freelists.org>; Sat,  9 Sep 2006 03:15:42 -0400 (EDT)
Received: by ug-out-1314.google.com with SMTP id s2so860597uge
        for <oracle-l@freelists.org>; Sat, 09 Sep 2006 00:16:07 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=hC+uprbyzM59EAauibIrTOlxLuZ8M8V/PX1bU5iEPcTnEid9/K+n+zUzr6xQNNNaZLOXUNWaYBZr/CJ+kfzOpkoQygqQq0D3gWc0aGDUj8l+nngBWluXVQaGTZielM6XWlg0qq7ot+1kvRR4u3Q0eVK3Grx7pXQcvQEGavMZctg=
Received: by 10.66.242.20 with SMTP id p20mr1493394ugh;
        Sat, 09 Sep 2006 00:16:07 -0700 (PDT)
Received: by 10.67.99.17 with HTTP; Sat, 9 Sep 2006 00:16:07 -0700 (PDT)
Message-ID: <6e9345580609090016i88a724ds70692d6bee645afc@mail.gmail.com>
Date: Sat, 9 Sep 2006 09:16:07 +0200
From: "LS Cheng" <exriscer@gmail.com>
To: bnsarma@gmail.com
Subject: Re: Disk Async IO
Cc: _oracle_L_list <oracle-l@freelists.org>
In-Reply-To: <61292a9d0609061154o9ed62dpdf46a37650f17931@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_117822_7186095.1157786167255"
References: <61292a9d0609061154o9ed62dpdf46a37650f17931@mail.gmail.com>
X-archive-position: 39204
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: exriscer@gmail.com
Precedence: normal
Reply-to: exriscer@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_117822_7186095.1157786167255
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

I think if you have Veritas Quick I/O it would have similar performance as
RAW Device.

If you have OnlineJFS without the Quick I/O then your parameters is doing
nothing as other suggested. However with Online JFS you can use direct I/O
which has a decent performance, by default direct I/O is not enabled, you
have to modify the mount options.

Both Online JFS and Veritas Quick I/O are very expensive though....


Rgds


On 9/6/06, BN <bnsarma@gmail.com> wrote:
>
>  Greetings,
>
> I remember reading Oracle Metalink  Notes saying that Disk Async IO is not
> supported on HP-UX for Cooked Filesystems.
>
> We have disk_async_io=true for our Database in HP-UX 11.11 , Oracle
> 8.1.7.4 and 10g Servers.
>
> I would like to ensure that my understanding and setting is right.
>
> Right now we are using 4 dbwr's. I appreciate  your suggestions.
>
> Our UNIX SA says  " Cooked Filesystems have their own Asynchronous
> Mechanisim that equally replaces Oracle Async IO"
>
> What Am I missing here
>
> Appreciate your suggestions.
>
> --
> Regards & Thanks
> BN
>

------=_Part_117822_7186095.1157786167255
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi</div>
<div>&nbsp;</div>
<div>I think if you have Veritas Quick I/O it would have similar performance as RAW Device.</div>
<div>&nbsp;</div>
<div>If you have OnlineJFS without the Quick I/O then your parameters is doing nothing as other suggested. However with Online JFS you can use direct I/O which has a decent performance, by default direct I/O is not enabled, you have to modify the mount options.
</div>
<div>&nbsp;</div>
<div>Both Online JFS and Veritas Quick I/O are very expensive though....</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Rgds<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 9/6/06, <b class="gmail_sendername">BN</b> &lt;<a href="mailto:bnsarma@gmail.com">bnsarma@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div>Greetings,</div>
<div>&nbsp;</div>
<div>I remember reading Oracle Metalink&nbsp; Notes saying that Disk Async IO is not supported on HP-UX for Cooked Filesystems.</div>
<div>&nbsp;</div>
<div>We have disk_async_io=true for our Database in HP-UX 11.11 , Oracle <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://8.1.7.4/" target="_blank">8.1.7.4</a> and 10g Servers.</div>
<div>&nbsp;</div>
<div>I would like to ensure that my understanding and setting is right.</div>
<div>&nbsp;</div>
<div>Right now we are using 4 dbwr's. I appreciate&nbsp; your suggestions.</div>
<div>&nbsp;</div>
<div>Our UNIX SA says &nbsp;&quot; Cooked Filesystems have their own Asynchronous Mechanisim that equally replaces Oracle Async IO&quot;</div>
<div>&nbsp;</div>
<div>What Am I missing here</div>
<div>&nbsp;</div>
<div>Appreciate your suggestions.<br clear="all"><br>-- <br>Regards &amp; Thanks<br>BN </div></div></blockquote></div><br>

------=_Part_117822_7186095.1157786167255--
--
http://www.freelists.org/webpage/oracle-l


