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 busy waits.
- "Koivu, Lisa" <lisa.koivu_at_efairfield.com> wrote:
> 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:joni_65_at_yahoo.com]
> > Sent: Tuesday, August 21, 2001 11:21
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Freelist Contention
> >
> > Bufer busy waits can also be caused by parallel
> query
> > servers trying to read the same buffer block at
> the
> > same time. So does it always indicate a freelist
> > problem?
> > .
> > --- Jon Walthour <jonw_at_fuse.net> wrote:
> > > Raja:
> > >
> > > You will know you have freelist contention if
> you
> > > have a significant
> > > buffer busy waits ratio (>5%).
> > >
> > > Jon Walthour
> > >
> > > -----Original Message-----
> > > Luthra
> > > Sent: Monday, August 20, 2001 11:45 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello folks,
> > >
> > > How do I come to know that there is a contention
> > > going on in the
> > > freelists? Is there any v$ table or this type of
> > > contention you derive
> > > from some other info. like a ripple effect from
> some
> > > parameter?
> > >
> > > TIA.
> > >
> > > raja
> > >
> > >
> > > Get 250 color business cards for FREE!
> > > http://businesscards.lycos.com/vp/fastpath/
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Viraj Luthra
> > > INET: viraj999_at_lycos.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).
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Jon Walthour
> > > INET: jonw_at_fuse.net
> > >
> > > 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).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Johnson Poovathummoottil
> > INET: joni_65_at_yahoo.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).
>
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.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 Aug 21 2001 - 13:47:43 CDT