Re: Tuning DBWR

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 13 Jan 2000 19:00:59 +0800
Message-ID: <387DB06B.734A@yahoo.com>

sandrazil_at_my-deja.com wrote:
>
> 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.

• Check for basic IO contention
• Make sure your log_buffer is not too high
• Is "db_files" set too high

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 13 2000 - 05:00:59 CST