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 -> Re: What is better asychronous IO or multiple db_writers?

Re: What is better asychronous IO or multiple db_writers?

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 1998/01/19
Message-ID: <slrn6c6tk8.r18.oracle@tchp2.tcamuk.stratus.com>#1/1

In article <34C23B75.9C10670C_at_mace.be>, Peter Verhaegen wrote:

As far a I remember, if you switch on Async-IO on HP-UX (Kernel Parameter) and have you datafiles in filesystems (ADFS or BSD 4.2), you can corrupt your database.

Use multiple DB Writers - (about 2 x No-of-disks works well for me)

Neil Chandler

>As far as I know, on HP-UX async IO is only possible if you use raw
>devices. If you use file system based files then you have to simulate async
>IO thru multiple db writers.
>
>Matt Larson wrote:
>
>> We have several 7.3.3 databases running on hp 10.20. What are the pluses
>> and minuses of both asychronous IO and multiple DB_WRITERS? Also, has
>> anyone had problems with either of these on HP?
>>
>> Please email answers to matt_larson_at_jdedwards.com
>>
>> Thanks in advance,
>> Matt
>
>
>
Received on Mon Jan 19 1998 - 00:00:00 CST

Original text of this message

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