How to set DBWR_WRITE_PROCESSES in Oracle8i?

From: CC Harvest <ccharvest_at_yahoo.com>
Date: Tue, 15 Jan 2002 17:49:01 -0800
Message-ID: <F001.003F0D9F.20020115171531@fatcity.com>

Hi, gurus:

The database is oracle8.1.7.2.1 on win2k machine with 1 CPU and two hard drives. When I query v$waitstat, I got the following:

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block          246901435  132690159
segment header           4869       8018
undo block              20986      38476
undo header              1895       1556

seems like I need to set DBWR_WRITE_PROCESSES to a higher number, what number should I choose, 2 or bigger?

Also, what other problems can you see from the last query, other than we need to add some more RBS?

Thanks,

Chris Harvest.

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CC Harvest
INET: ccharvest_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Jan 15 2002 - 19:49:01 CST