Re: db_writer_processes, dbwr_io_slaves, db_block_lru_latches and

Just found some good info for tuning AIX and setting up async io.

Chapter 12 of 'Oracle Performance Tuning 101', gives the info you need for this.

http://www.amazon.com/exec/obidos/ASIN/0072131454/qid=991794807/102-7293403-1080948

Jared

On Tuesday 05 June 2001 13:50, Post, Ethan wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.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).