Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES

Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 09 Jan 2004 11:39:27 -0800
Message-ID: <F001.005DC48E.20040109113927@fatcity.com>


Thomas:

I think you are right on monitoring the db writer performance. You should look the write complete waits/ free buffer waits to understand the db writer contention. I am not sure what prompted your Sr.DBA to think on increasing the IO slaves or db writers.

KG


Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 09 2004 - 13:39:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US