Home » RDBMS Server » Server Administration » DBWR_IO_SLAVES values
DBWR_IO_SLAVES values [message #164504] Thu, 23 March 2006 13:18 Go to next message
sivas
Messages: 1
Registered: March 2006
Junior Member
Hi,

Oracle signals a ORA-27062 if after waiting a reasonable amount of time the Operating System is not completing async I/O requests.

Documentation suggests a workaround to set DISK_ASYNCH_IO to false and DBWR_IO_SLAVES to a value other than its default of zero in order to simulate asynchronous I/O.

Can you pls suggest me what value could be chosen for DBWR_IO_SLAVES to gain optimum performance ?

Report message to a moderator

Re: DBWR_IO_SLAVES values [message #164550 is a reply to message #164504] Thu, 23 March 2006 23:37 Go to previous message
Frank Naude
Messages: 4593
Registered: April 1998
Senior Member
Quote:

The general recommendation is: set the value to 2, if the I/O activity is expected to be moderate. Set it to 4, if you expect a lot of I/O activity. Simulating asynchronous I/O behavior is not free. So, deployment of I/O slaves should be done carefully. I cannot stress this point enough.


Source: http://www.fors.com/velpuri2/PERFORMANCE/io_slaves.htm

Report message to a moderator

Previous Topic: Why the owner of archivelog is root?
Next Topic: Oracle Patchset
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 18:47:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.