if I do a query such as


select
w.class block_class,
w.count total_waits,
w.time time_waited
from
sys.v_$waitstat w
where
w.count > 0
order by 3 desc
/

I get this result ?

SQL> @buffer_busywaits.sql

BLOCK_CLASS TOTAL_WAITS TIME_WAITED
------------------------------ ----------- -----------
undo header 39 116
data block 1 0
undo block 8 0

3 rows selected.


Could you suggest which factor I need to cconsider to reduce the waits.

Thanks