Re: DBWR consumes a lot of CPU

Just some General tips which might help :

1. Try to Reduce the Frequency of Database Checkpoints using LOG_Checkpoint_Interval = 99999999 which causes checkpoints to Occur only when the Log Switches occur..
2. Start Multiple DBWRs if the Database is heavily write intensive.. 3 . Detect if the Datafiles are facing Writie Contention .. If Yes, Try moving the write intensive files to separate Disks..

Hope this helps..

-Thiru

NetComrade wrote:

> Hi,
>
> I have noticed in my 'top' that some process wakes up from time to
> time and consumes up to 20% of CPU, so I checked V$process, and it
> showed to me that it was DBWR. Can somebody explain what's goin gon
> behind this. Actually....
> oracle 640 1 8 Sep 07 ? 123:51 ora_dbwr_FOOT
> Why does this thing east so much CPU? That's in 36 hours.
>
> Another DB which is somewhat less active has
> oracle 843 1 0 Aug 18 ? 127:11 ora_dbw0_MEL2
> and that's in more then 3 weeks
>
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Fri Sep 10 1999 - 13:40:10 CDT