Performance tuning the db_writer_process in Oracle v11g
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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.