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 -> Oracle8 performance problem

Oracle8 performance problem

From: Little Prince <milan1810_at_geocities.com>
Date: Fri, 18 May 2001 00:39:43 +0800
Message-ID: <9e0ut8$b452@ctmsun0.macau.ctm.net>

When I query v$waitstat, the following appears:

  CLASS COUNT TIME

         The above statistics shows a lot of waits in data block,  segment header, undo header and undo block. What do they mean? How can  I reduce the waits?

Regards,
Andrew

--
Received on Thu May 17 2001 - 11:39:43 CDT

Original text of this message

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