Performance tuning the db_writer_process in Oracle v11g
Posted on 2011-03-21
I recently updated my system to Oracle v11g from oracle 9i. In Oracle 9, the db_writer_process was set by default to 1, but in v11 db_writer_process is set to 4.
Also with v11 i get a message in my alert logs that reads Private strand flush not complete which i have read as being a normal message for oracle 11. Oracle also says that i can get rid of this message by increasing the value of db_writer_process.
Does anyone have any information on how performance is affect by increasing or decreasing the db_writer_process parameter?
Any help is greatly appropriated, Thank YOu