Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance Problem

549855May 28 2009 — edited May 31 2009
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2009
Added on May 28 2009
20 comments
4,228 views