Re: What's the difference between DBWR_IO_SLAVES and DB_WRITER

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 08 Jul 1999 18:18:23 GMT
Message-ID: <19990708141823.27463.00004890@ngol03.aol.com>

In article <930070957.19561.1.nnrp-06.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> writes:

>Consequently you could have a 'collection bottleneck' in
>your system by having only one db_writer (other processes
>may see excessive blocks pinned waiting for writes) even
>when you have multiple I/O slaves.
>

Actually if you specify a number for DBWR_IO_SLAVES > 0 then it doesn't matter what number you apply to DB_WRITER_PROCESSES because Oracle will only give you one of them...

Paul in VT Received on Thu Jul 08 1999 - 13:18:23 CDT

Re: What's the difference between DBWR_IO_SLAVES and DB_WRITER_PROCESSES?