RE: buffer busy waits what does p3=130 mean

From: Satheesh Babu.S <satheesh.babu_at_iflexsolutions.com>
Date: Tue, 13 Jul 2004 21:27:05 +0530
Message-ID: <GCEBLIIOHAGINCMOOPLNCECPCBAA.satheesh.babu@iflexsolutions.com>

p3 is a reason code,
p3=130 mean,
"Block is being read by another session and no other suitable block image was found, so we wait until the read is completed. This may also occur after a buffer cache assumed deadlock. The kernel can't get a buffer in a certain amount of time and assumes a deadlock. Therefor it will read the CR version of the block. "

Thanks and Regards,
Satheesh Babu.S
Bangalore.
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad Sent: Tuesday, July 13, 2004 9:16 PM
To: oracle-l_at_freelists.org
Subject: buffer busy waits what does p3=130 mean

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

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

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