Re: multiple dbwr's and deadlock

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Tue, 08 May 2001 10:47:08 GMT
Message-ID: <3af7ccbe.9561390@news-server>

On Tue, 08 May 2001 07:21:57 GMT, Anjo Kolk <k.kolk_at_chello.nl> wrote:
>So what to do in your case:
>
>1) db_block_lru_latches = 4-8
>2) db_writers = 16 or even higher
>3) _db_block_write_batch = <something decent, less than (db_files *
>db_file_multi_block_read_count)/2).
>

PMFJI. Shouldn't 1) be (indirectly) related to the number of CPUs? By this I mean for example: 4 CPUs, 8 DBWR, then 1) = 4? Or is it "no relation"?

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Tue May 08 2001 - 05:47:08 CDT