Re: VxFS threaded AIO vs. DBWR Slaves
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-lReceived on Mon Feb 25 2008 - 16:09:29 CST