Re: Multiple DBWR

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 25 Jun 1998 13:38:13 GMT
Message-ID: <35935277.3389513@192.86.155.100>

A copy of this was sent to "zaid" <mohdzaid_at_pacific.net.sg> (if that email address didn't require changing) On Thu, 25 Jun 1998 16:30:38 +0800, you wrote:

>Hi,
>
>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...

>
>Best Regards,
>Zaid
>Systems Engineer
>Siemens Medical Instruments Pte Ltd
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jun 25 1998 - 08:38:13 CDT