Hello..
I am posting the result of selecting from v$waitstat here:
SQL> select * from v$waitstat;
CLASS COUNT TIME
------------------ ---------- ----------
data block 1086905 3391010
sort block 0 0
save undo block 0 0
segment header 479 120669
save undo header 0 0
free list 2 118
system undo header 0 0
system undo block 0 0
undo header 715 3514
undo block 352 4600
My question is how come I am experiencing so many waits for undo header/block?? I had 50 2 meg rollback segments and added 10 more yesterday and the count for header waits has increased by almost 100!! I am not getting any errors, it's just that my users constantly complain about slow response time and I am trying to do something about it. This is a 67 gig OLTP/Batch database that does mainly OLTP during the day and batch at night. I do have a lot of chained rows in some tables due to the use of long datatype. I just do not understand why my undo waits keep going up??? Any advice would be greatly appreciated.
Thank you..
