Re: VxFS threaded AIO vs. DBWR Slaves

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 25 Feb 2008 14:09:29 -0800
Message-ID: <a9c093440802251409g486ea113p95b114c23abf2412@mail.gmail.com>


I would suggest using ASM. Then you can leverage all the benefits and not have to worry about file layout.

If you use threaded async or emulate async by multiple db writers, its probably the same overhead.

On 2/25/08, Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote:
> Hi All,
>
> I'm building a 10g database on a VxFS filesystem on HP-UX. I understand this does not support kernelized asynchronous I/O but does support threaded asynchronous I/O which I believe has a significant CPU overhead. So: should I use the threaded asychronous I/O from VxFS (FILESYSTEMIO_OPTIONS=SETALL) or should I switch it off, and use multiple database writer slaves instead?
>
> My aim is targeted towards performance rather than capacity (i.e. small number of users in database).

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 25 2008 - 16:09:29 CST

Original text of this message