Re: VxFS threaded AIO vs. DBWR Slaves

  • From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
  • To: charlottejanehammond@xxxxxxxxx
  • Date: Mon, 25 Feb 2008 14:09:29 -0800

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: