Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL> select class,count from v$waitstat; show data block contention
I am experiencing some I/O degredation as the below data block numbers keep going up.
Thinking about recreating the tables and increasing the freelists and inittrans. Is this my best course of action?
SQL> select class,count from v$waitstat;
CLASS COUNT
------------------ ----------
data block 86357 sort block 0 save undo block 0 segment header 0 save undo header 0 free list 0 extent map 0 bitmap block 0 bitmap index block 0 unused 0 system undo header 0 CLASS COUNT
------------------ ----------
system undo block 0 undo header 0 undo block 5
14 rows selected.
SQL> Received on Mon Mar 12 2001 - 11:20:40 CST
![]() |
![]() |