RE: Async I/O on Sun Solaris

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:	Stephen.Karniotis_at_Compuware.com
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"
>>>
>>> <Helmut.Daiminger_at_KirchGruppe.de> 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
>>> pnbarne_at_regence.com
>>>
>>> __________________________________________________
>>> 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: regdba_at_yahoo.com
>>>
>>> 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com
>
> 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: ListGuru_at_fatcity.com (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: george_at_omniti.com

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: ListGuru_at_fatcity.com (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: Stephen_Karniotis_at_compuware.com

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: ListGuru_at_fatcity.com (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: JayMiller_at_TDWaterhouse.com

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: ListGuru_at_fatcity.com (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).