What happens when you join a large parllelized table
with a very small table (contained in just 10 or 12
blocks) the retrieval of rows from the large table
looks up the small table causing buffer busy waits on
the blocks of the small table. Keeping the small table
in keep pool removes the buffer b
Another thing that comes to mind is incorrectly tuned DBWR, which cannot
keep up.
> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Freelist Content
Title: RE: Freelist Contention - PQ slaves
I thought that parallel query slaves were smart enough to divide up the work between them so there was no overlap? What am I missing? Can you elaborate?
-Original Message-
From: Johnson Poovathummoottil [SMTP:[EMAIL PROTECTED]]
Sent