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 -> "Reasonable" Wait statistics??

"Reasonable" Wait statistics??

From: Harry Boswell <hboswel1_at_bellsouth.net>
Date: Tue, 11 Jun 2002 16:12:39 GMT
Message-ID: <3d061ff2.694762355@news1.lig.bellsouth.net>


I've done a Google search for guidelines on this, but I haven't found clear answers. When I check my production instance using TOAD's Server Stats, I see some wait stats that seem high, but are they really high? For example:

db file scattered read 16264
db_sequential_file_read 4642169

dispatcher timer 4915441

latch free 101389

pmon timer 152556

SQL*Net message from client     2429529
SQL*Net message to client       2429496
SQL*Net more data from client    65029
SQL*Net more data to client      1491867

virtual circuit status           2278288



Are these numbers high, or is a high number to be expected?

Thanks,
Harry Received on Tue Jun 11 2002 - 11:12:39 CDT

Original text of this message

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