Re: EMC Storage Array Issue

Claudio,

All writes in Oracle are synchronous, they are just fired asynchronously. So even the DBWR writes synchronously.
So individual writes are synchronously, they are just fired off asynchronously.

Anjo Kolk.

claudio cutelli wrote:

> Hi,
> which background process had the problem?
> because if lgwr, it already write in sync mode ...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, April 15, 2002 5:33 PM
>
> > We have implemented a Sun Solaris Cluster (4 machines), connected to
> > an EMC storage array. The migration began last fall, and we now have 15
> > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We
> > recently have had 2 occurances of asynchronous I/O wait times exceeded.
> > When this occurs, every database crashes at the same time. The solution
> > from EMC is to turn asynchronous I/O off in all of the Oracle instances
> > (disk_async_io = false) and to increase the database writer slaves
> > (dbwr_io_slaves = <something not 0>) to emulate asynchronous I/O.
> > Has anyone run into this problem before? If so, how did you
> > "correct" it? My feeling is that EMC is trying to give us a bandage to
> > cover up the real problem, by trying to get Oracle to ignore it.
> >
> > Thank you.
> >
> > --
> > Scott Canaan (srcdco_at_rit.edu)
> > (585) 475-7886
> > "Life is like a sewer, what you get out of it depends on what you put
> > into it" - Tom Lehrer
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Scott Canaan
> > INET: srcdco_at_ritvax.rit.edu
> >
> > 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: claudio cutelli
> INET: c_cutelli_at_hotmail.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: Anjo Kolk
  INET: anjo_at_oraperf.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).