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!
Hi All, I am trying to analyze an AWR report which shows "log file sync" in Top timed and Network class as well. I ask for AWR report in hope to get any event related with SQL Execution but did not found any. Also the Application SQL's which I was expecting to be part of AWR are not present (I am sure that those SQL/ PLSQL were running for AWR begin and end time because we log time for process start and end in a table). From the AWR I can deduce few things like most of log file sync is happening on Instance 4 and it is doing 903 commits per second, average time wait is 8.34 ms and log writer I/O is ~1.13 ms I have included most part of AWR report it is taken for 15 minutes purpose of this analysis is to look for possible bottlenecks in performance which we are facing on production