Re: Multiple DBWR

Thomas, could I ask you a question about DBWR>1? I'm working from Digital Unix with one CPU so maybe this doesn't apply: One day I asked about multiple writers and I think Support said that there was an OS parameter that --should not-- be asynch if my dbwr > 1 because it would create errors. Now I see that you're looking at an --internal parameter-- covering the same ground...which of these are "usable" with DBWR > 1 (OS asynch y/n; param asynch y/n)?

Would appreciate being straightened out! Thanks in advance...

> >I am running on Oracle 7.3.2 on Solaris 2.5.1. Currently I have only one
> >DBWR. I would like to enable more DBWR inorder to improve I/O performance.
> >Has anyone tried enabling multiple DBWR. If yes how much has the I/O
> >performance improve? Many thanks...
> solaris supports async io to both cooked and raw filesystems. Just make sure
> async io is enabled, eg:
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> show parameter async
> NAME TYPE VALUE
> ----------------------------------- ------- ------------------------------
> disk_asynch_io boolean TRUE
>
> If async io is on, having more then 1 dbwr is a waste as multiple dbwrs are only
> used to mimick async io...
>
> Thomas Kyte

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 25 1998 - 23:50:43 CDT