Re: buffer busy waits what does p3=130 mean

From: <Rajesh.Rao_at_jpmchase.com>
Date: Tue, 13 Jul 2004 11:59:22 -0400
Message-ID: <OF57718E1E.44ADD981-ON85256ED0.00579309@chase.com>

Buffer busy waits are usually due to hot blocks. In your case, look like session A is reading a block from disk into the cache. Your session is waiting for this read to finish (p3=130).

Regards
Raj

                                                                                                                        
                    Fuad Arshad                                                                                         
                    <fuadar_at_yahoo.com>        To:     oracle-l_at_freelists.org                                            
                    Sent by:                  cc:                                                                       
                    oracle-l-bounce_at_fre       Subject:     buffer busy waits what does p3=130 mean                      
                    elists.org                                                                                          
                                                                                                                        
                                                                                                                        
                    07/13/2004 11:46 AM                                                                                 
                    Please respond to                                                                                   
                    oracle-l                                                                                            
                                                                                                                        
                                                                                                                        

Anyone know what 130 in the p3 mean for buffer busy waits. we are having issues with a query looping thru buffer busy waits as below. i'm trying to find out what 130 means in the p3 field.

WAIT #9: nam='buffer busy waits' ela= 46935 p1=19 p2=150808 p3=130
WAIT #9: nam='buffer busy waits' ela= 481 p1=37 p2=21714 p3=130
WAIT #9: nam='buffer busy waits' ela= 11138 p1=19 p2=91562 p3=130
WAIT #9: nam='buffer busy waits' ela= 560 p1=75 p2=230509 p3=130
WAIT #9: nam='buffer busy waits' ela= 594 p1=19 p2=211271 p3=130
WAIT #9: nam='buffer busy waits' ela= 398 p1=19 p2=94800 p3=130





----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jul 13 2004 - 10:56:55 CDT