I don't think it's goona help because io_slaves are to share the work the got from the dbwr. instead more dbwrs are gonna help because they are gonna get and write directly. one dbwr is gonna pick up the same no of blocks at a time io_slaves are only to write that load faster.
04-09-2001, 11:34 AM
You cannot use both dbwr_io_slaves and db_writer_processes. Which one to use depends on if your OS supports async or sync I/O, and which one performs better. Accordingly, you would set the appropriate value for the init.ora parameter, disk_async_io.
04-09-2001, 11:57 AM
AIX supports asynchronous IO. Configure sufficient AIO servers and run with disk_async_IO & one DB writer. It will give much better performance.
04-09-2001, 07:40 PM
mbaliga. I have a question for U.
How many db_block_lru_latches have U set for the 'one DB writer' ??
Would it be better to give more lrulatches ??