Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Async writes or multiple DBWRs?

Async writes or multiple DBWRs?

From: <tgp_at_mci2000.com>
Date: Wed, 27 May 1998 14:40:31 GMT
Message-ID: <6kh8kv$9td$1@nnrp1.dejanews.com>

I'm looking for a definitive answer to the question: Given that I am running Oracle on AIX 4.2.1, with all Oracle database files on JFS, and not on raw partitions, should I use async I/O, or multiple DBWR processes?

I have found scattered references to the two options in various books and manuals, and concluded that I should use async writes. Then an Oracle consultant guy I know who seems intelligent (but you know consultants!) said he "thinks he read somewhere" that you shouldn't use async writes on JFS files, but only on raw partitions.

Can someone give me a convincing argument for using one or the other, or point me to holy Oracle documentation that answers the question?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 27 1998 - 09:40:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US