dbwr_io_slaves or db_writer_processes
412352May 12 2009 — edited May 13 2009Im having a little trouble understanding the situations in which using dbwr_io_slaves would be better than db_writer_processes, it would be nice if someone could explain it clearly or point me to documentation that explains it cleary.
I have a secondary question which im pretty sure is related, which is, one of the databases that I deal with has a large number of dirty buffers (ie: > 600,000) at the moment the only way I know to clear this and reduce the number is to restart the database from time to time (this is not something I want to be doing and need a better solution).
Some background information:
The database gets information loaded into it in batches on a nightly basis, the server the database runs on has two dual core cpu's with 8gb of ram, there are also a couple of other databases running on these systems as well.