RE: buffer busy waits what does p3=130 mean
- From: "Satheesh Babu.S" <satheesh.babu@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jul 2004 21:27:05 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad
Sent: Tuesday, July 13, 2004 9:16 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
