Performance Problem
549855May 28 2009 — edited May 31 2009Hi,
Bellow the Top 5 Timed Events in my awr report for the last 2 hours.
Could one suggest what to do with the first event : log file switch (private stran ?
Please note that i have maximum 4 switches per hour.
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
log file switch (private stran 119,321 80,227 672 31.1 Configurat
free buffer waits 5,618,813 56,907 10 22.1 Configurat
buffer busy waits 218,229 40,016 183 15.5 Concurrenc
db file sequential read 6,514,444 24,350 4 9.4 User I/O
SQL*Net break/reset to client 1,233 23,749 19261 9.2 Applicatio
select trunc(first_time, 'HH') , count(*)
from v$loghist
group by trunc(first_time, 'HH') ;
27-MAY-09 4
27-MAY-09 2
27-MAY-09 2
27-MAY-09 4
27-MAY-09 2
27-MAY-09 1
27-MAY-09 1
27-MAY-09 1
Thanks
Yoav