Yeah, like I said, I wasn't thinking too hard about it. :)
Jared
"Jonathan Lewis"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
mon.co.uk> cc:
Sent by: Subject: Re: Freelist Contention
[EMAIL PROTECTED]
08/21/01 11:46 AM
Please respond to
ORACLE-L
Not only that, PX slaves do direct reads
anyway, bypassing the buffer cache.
It is possible, though, that the flush
that has to take place before the PX
scan can read back is sufficient to
cause other processes to wait for
write complete waits, and I guess that
you could also get extra rbs header
waits as the flushed and scanned blocks
are rolled back by the PX slaves for
read consistency.
Excessive serial tablescans, on the other
hand can easily cause significant buffer
busy waits.
Jonathan Lewis
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
For latest news of public appearances
See http://www.jlcomp.demon.co.uk
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 21 August 2001 18:32
|On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
|> Bufer busy waits can also be caused by parallel query
|> servers trying to read the same buffer block at the
|> same time.
|
|Just off the top of my head, and without giving it a lot
|of thought, this doesn't sound right.
|
|PQS divvy up the blocks to read, and should not be trying
|to access the same block.
|
|Got any documentation or evidence to back that up?
|
|Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
