RE: excessive number of db writer

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 6 Sep 2006 16:24:41 -0700

>>> you still need to know the number of Disk 
>>>access points, I.E. devices.


>>>maybe you have all your disk access thru a single volume 
>>>(definitely not recommended).


>>>I usually try to come up with a number of DBWR processes as 
>>>a combination of CPU's available and devices that can be 
>>>written to. 


>>>It's all a matter of how many write processes can be active 
>>>at the same time.


>>>otherwise you will have processes waiting for CPU or the 
>>>device to free up for another DBWR to begin.



Other related posts: