Re: DB_WRITERS, ASYNC_WRITE & RAID ??
Date: 20 Nov 1994 23:35:24 GMT
Message-ID: <3aomfs$b08_at_fido.asd.sgi.com>
In article <3ajbvi$ni1$1_at_mhadg.production.compuserve.com>,
R. Scott Hunter <73373.2743_at_CompuServe.COM> wrote:
>If you're set up for asyncronous I/O in your particular UNIX
>configuration, I don't think you want to be enabling multiple
>database writers; I recall reading this in a number of places in
>the ICGs and the Oracle UNIX admin manuals.
This is absolutly port/platform dependent. Some ports will disable asyncio if you run multiple dbwr's (since the OS's on those platforms can't hanlde multiple Oracle processes doing asyncio) others won't. Some ports/platforms can just aboput handle any workload with one dbwr and aysncio and others can get a performance increase running a few dbwr each using asyncio. This is very platform specific, check with the vendors.
Remember this only helps if your database is write (not read) I/O bound.
>--
>R. (Scott) Hunter - Database Administrator - AT&T Tax Systems
>email: shunter_at_cfotax.attmail.com (AT&TMail: cfotax!shunter)
Cheers
Darryl
-- Darryl Ramm Silicon Graphics Database Marketing Manager 2011 North Shoreline Blvd. darrylr_at_sgi.com Mountain View, CA, 94039-1389 voice: (415) 390-2875 fax: (415) 390-6320Received on Mon Nov 21 1994 - 00:35:24 CET