VxFS threaded AIO vs. DBWR Slaves

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Mon, 25 Feb 2008 13:40:15 -0800 (PST)
Message-ID: <786365.24551.qm@web50202.mail.re2.yahoo.com>

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).

Thanks for any tips!


Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Received on Mon Feb 25 2008 - 15:40:15 CST

Original text of this message