Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> "Reasonable" Wait statistics??
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