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:45:05 CDT
