waits

  • From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 15 Nov 2007 09:30:31 -0500

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


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007