Re: Tuning DBWR

From: ora7dba <mikeo_at_tconl.com>
Date: Thu, 13 Jan 2000 19:00:41 -0600
Message-ID: <aBuf4.417$x84.8793@news.uswest.net>

What has not been discussed is ASYNC I/O ... using async i/o is faster than trying to add more DBWR's. HP's are a different animal (compared to sun's) so you need to check into your OS support for async i/o.

-Mike

<sandrazil_at_my-deja.com> wrote in message news:85iv71$o0f$1_at_nnrp1.deja.com...
> Hi All,
> I am having a performance problem whenever there is a log switch, and
> when DBWR writes dirty buffer to disk. It takes 2 minutes for DBWR to
> complete its job, during that time there is a I/O Bottleneck. I am
> running Oracle 8.05 on HPUX 11.0 ( 32 bit), i am running 4 DBWR's. I
> have performace problem only during this 2 minute interval. Any
> Suggestions is highly appreciated,
>
> Thanks,
>
> Sandra
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 13 2000 - 19:00:41 CST