db_writer_processes, dbwr_io_slaves, db_block_lru

From: Post, Ethan <epost_at_kcc.com>
Date: Tue, 05 Jun 2001 12:44:08 -0700
Message-ID: <F001.0031CD08.20010605125044@fatcity.com>

I have read about 20 different articles dealing with the setting of these parameters and I'm still tremendously confused. The first problem is determining if your OS supports async_io. Most of the info I find says "most" operating systems do but then I find that this is perhaps only true on raw volumes. I'm creating the INIT file for a large DB and the docs recommend setting up multiple db_writer_processes and setting disk_async_io to false in all cases. However, I have already found some recommends that are definitely wrong. We are installing on an RS6000 4*500 Mhz box with 2GB RAM. Should I configure 4 db_writer_processes right off the bat or should I go with one and wait to see if there is actually some DBWR contention? I have set up one db_block_lru_latch for each db_writer_process since I have no additional pools configured at this time. Then the next question is whether I go with dbwr_io_slaves instead? It seems the recommends have change since Oracle 8 and then changed back with 8i. By the way the disk is going to be EMC.

If someone can put together a nice little decision tree for this that would be cool.

Regrettably thick headed,
Ethan Post

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

--

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

Author: Post, Ethan
INET: epost_at_kcc.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 Jun 05 2001 - 14:44:08 CDT

db_writer_processes, dbwr_io_slaves, db_block_lru_latches and