Solved

Performance tuning the db_writer_process in Oracle v11g

Posted on 2011-03-21
4
6,990 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Alex Matzinger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35187209
Increasing this parameter is also likely to have minimal effect on single-CPU systems.  Increasing this parameter could, in fact, reduce performance on systems where the CPU’s are already over burdened.  In cases where the main performance bottleneck is that a single DBWR process cannot keep up with the work load, then increasing the value for DB_WRITER_PROCESSES may improve performance.

When increasing DB_WRITER_PROCESSES it may also be necessary to increase the DB_BLOCK_LRU_LATCHES parameter, as each DBWR process requires an LRU latch.

Default value of DB_WRITER_PROCESSES is 1 or CPU_COUNT / 8, whichever is greater. If the number of processor groups is less than 36 but greater than the number of DB writer processes, then the number of DB writer processes is adjusted to be a multiple of the number of processor groups. If the number of DB writer processes is greater than or equal to the number of processor groups, then there is no adjustment.

0
 
LVL 4

Author Comment

by:Alex Matzinger
ID: 35234551
Thank you for your response, Is there any tool i can use to tune this feature in oracle.  I have two very similair systems, but one has 4 log writers, and the other has 20 log writers, is there a way i can tell the difference.  I don't want to increase the number of log writers, and have it negatively affect my system.  

Adidtion note:  My system has 32 CPU's
0
 
LVL 4

Author Comment

by:Alex Matzinger
ID: 35235320
I would also like to note that my system is using Async IO.
0
 
LVL 4

Author Closing Comment

by:Alex Matzinger
ID: 35750355
Thank You, your info was spot on.  Ended up testing several different db_writer values to find the best fit.  Thank You
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question