Oracle/Solaris does a decent job of faking asynch i/o, but it isn't real. The details are on Steve Adam's website (www.ixora.com.au).
Jay Miller -----Original Message----- Sent: Monday, February 18, 2002 1:33 PM To: Multiple recipients of list ORACLE-L I don't think you need raw devices for asynch I/O. We used asynch I/O without raw for years quite successfully. Veritas vxfs with Q I/O also helped. You need raw if you are going to implement Oracle9i RAC or Oracle Parallel Server. If not the issue, I would highly recommend asynch I/O over synchronous I/O to eliminate the intercommunication between the slave processes. Not to mention the memory consumption. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Monday, February 18, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Async I/O on Sun Solaris Works like a charm against qio files as well. May work on vxfs (I haven't checked). It may be a metter of definition, but I wouldn't characterize not working on ufs as not working on Solaris. That seems an overly sweeping statement to me. George On Saturday, February 16, 2002, at 09:03 PM, Jared Still wrote: > > Well, no not actually. > > You must use raw devices for async IO to work with Oracle on Solaris. > > It's pretty easy to prove this using svrmgrl and truss. If you dig > around > in the archives you may find some references to it, or search on google > as there are a couple of sites that archive this list. > > With cooked filesystems, you won't get async IO on Solaris, at least > on 2.6 and 2.7. Not sure about 2.8. > > Jared > > On Saturday 16 February 2002 16:08, George Schlossnagle wrote: >> Huh? >> >> asynch_io works fine on Solaris. At least on Solaris 2.6, 7, and 8. >> >> On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote: >>> Async IO on Solaris does not work - or at least it has >>> not worked with lower OS releases. Someone might have >>> more up to date information on Solaris 8. >>> >>> >>> --- "Daiminger, Helmut" >>> >>> <[EMAIL PROTECTED]> wrote: >>>> Hi! >>>> >>>> How can I find out whether my operating system >>>> supports async I/O? Can I >>>> turn this on/off? >>>> >>>> What is the relation between async I/O and the usage >>>> of Oracle I/O slaves? >>>> >>>> Can anybody shed some light on this? >>>> >>>> This is 8.1.7 on Sun Solaris 8. >>>> >>>> Thanks, >>>> Helmut >>> >>> ===== >>> Pete Barnett >>> Lead Database Administrator >>> The Regence Group >>> [EMAIL PROTECTED] >>> >>> __________________________________________________ >>> Do You Yahoo!? >>> Got something to say? Say it better with Yahoo! Video Mail >>> http://mail.yahoo.com >>> -- >>> Please see the official ORACLE-L FAQ: http://www.orafaq.com >>> -- >>> Author: Peter Barnett >>> INET: [EMAIL PROTECTED] >>> >>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >>> San Diego, California -- Public Internet access / Mailing Lists >>> -------------------------------------------------------------------- >>> To REMOVE yourself from this mailing list, send an E-Mail message >>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>> the message BODY, include a line containing: UNSUB ORACLE-L >>> (or the name of mailing list you want to be removed from). You may >>> also send the HELP command for other information (like subscribing). >> >> // George Schlossnagle >> // 1024D/1100A5A0? 1370 F70A 9365 96C9 2F5E?56C2 B2B9 262F 1100 A5A0 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > // George Schlossnagle // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).