Hi

The following is the statistic from v$waitstat.

CLASS COUNT TIME
------------------ ------------------- -------------------
data block 24667428 0
sort block 0 0
save undo block 0 0
segment header 34 0
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 165633 0
undo block 38002 0


From the statistic, I noticed that the undo header figure is high. I have re-created my rollback segment to a bigger size, but the undo header figure did not drop, why is this so?


The data block figure is also very high, any ways to reduce it?

Please help!!! Many Thanks!