Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL> select class,count from v$waitstat; show data block contention

SQL> select class,count from v$waitstat; show data block contention

From: James Williams <techsup_at_mindspring.com>
Date: Mon, 12 Mar 2001 17:20:40 GMT
Message-ID: <3aad04e3.839643@news.mindspring.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US