[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

what is the relation between CPU and DB WRITERS

Posted on 2011-04-19
3
Medium Priority
?
237 Views
Last Modified: 2012-12-21
I am deploying oracle 11g rel.2 on Linux with 24 cpu sun boxes.
How many number of db writers I need to configure for high intensity i/o environment.
0
Comment
Question by:suresh8487
1 Comment
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 35427049
"high intensity" is relative

I suggest starting with the default and adjust upward as necessary.
If your DBWR processes seem to fall behind, also check your LGWR to see if it's keeping up on redo.  DBWR won't write if it's waiting on LGWR to complete

for more info see the concepts manual

http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/process.htm#BABHDJGD
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month18 days, 1 hour left to enroll

830 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