Re: Freelist Contention

Yeah, like I said, I wasn't thinking too hard about it. :)

Jared

                                                                                       
                                  
                    "Jonathan Lewis"                                                   
                                  
                    <jonathan_at_jlcomp.de       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    mon.co.uk>                cc:                                      
                                  
                    Sent by:                  Subject:     Re: Freelist Contention     
                                  
                    root_at_fatcity.com                                                   
                                  
                                                                                       
                                  
                                                                                       
                                  
                    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 <ORACLE-L_at_fatcity.com> 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: jonathan_at_jlcomp.demon.co.uk

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: 
  INET: Jared.Still_at_radisys.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).