Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> q: buffer busy wait(data block wait) when P3=130

q: buffer busy wait(data block wait) when P3=130

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 6 Jan 2002 07:18:03 -0800
Message-ID: <44a19320.0201060718.3acf12ee@posting.google.com>


all,

  1. table cause the following waits had been identified. this table defined with default freelists and freelist group and intrans.
  2. the session_wait p3 = 130 according to steve adams.

   1013 Block is being read by another session and no other  or 130 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. Therefore it
           will read the CR version of the block.

3. Question: would increaing freelists/freelist group/intrans would
             help in reducing data block wait when p3 = 130 ?

thnx ted chyn

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block           93008976   52547847
sort block                  0          0
save undo block             0          0
segment header           1315        875
save undo header            0          0
free list                   0          0
extent map                  0          0
bitmap block                0          0
bitmap index block          0          0
unused                      0          0
system undo header          0          0
system undo block           0          0
undo header              1819        228
undo block              13722       6505
Received on Sun Jan 06 2002 - 09:18:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US