Data block and buffer busy quite high, suggestions?

Hello,

I have a rather slow 8.0.5 instance and am trying to figure out how to make it faster. Hopefully someone can point me in the right direction on why the data block numbers below are so high?

After four and a half day running, v$waitstat reports this:

CLASS                   COUNT       TIME


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

data block              31158    1583793
sort block                  0          0
save undo block             0          0
segment header             54         22
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

CLASS                   COUNT       TIME


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

system undo block           0          0
undo header             29648       1537
undo block                675        271

and v$system_event reports

event                 TOTAL_WAITS TIME_WAITED AVERAGE_WAIT
--------------------- ----------- ----------- ------------
buffer busy waits           61528     1585576   25.7699909

The next query returns no rows, hopefully indicating that I don't have a free list contention problem?

    select s.segment_name, s.segment_type, s.freelists     from dba_segments s, v$session_wait w     where w.p1 = s.header_file
    and w.p2 = s.header_block
    and w.event = 'buffer busy waits'
    ;

Thanks in advance for all hints, pointers or suggestions to why my "data block" wait count is so large.

Bjørn Augestad Received on Tue Jan 20 2004 - 09:27:52 CST