waits

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Thu, 15 Nov 2007 09:30:31 -0500
Message-ID: <473C5807.3010808@tufts.edu>

We have been having performance issues since we upgraded from 8i to 10.2.0.3. OS is aix 5.2.

Someone showed me the results from a query against v$system_event but I'm not sure if the number of waits or the average waits is high. Can anyone comment about this or tell me where I can find info about what numbers are "too high"? :

EVENT                 TOTAL_WAITS TIME_WAITED AVERAGE_WAIT


---------------------------------------------------------------- 


db file parallel read 1959        1988                  1.01
latch: shared pool    135658      226721              1.67
latch free            11828      19785                1.67
latch: cache buffers chains 5735       13096              2.28
latch: library cache        140371      719066            5.12
log file sequential read     1398        8014                5.73

Thanks.
Joe

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 15 2007 - 08:30:31 CST