RE: Log file sync waits

I guess you are after a query from AWR. I normally use the queries and a set of excel-based macros bundled up in perfsheet4 as described in: http://externaltable.blogspot.com/2015/02/latest-updates-to-perfsheet4-tool-for.html BTW I would recommend looking at the latency details in dba_hist_event_histogram in AWR. Another point is that I would also quickly look at the log writer's log file to check for signs of adaptive log file sync kicking in.

Cheers,
Luca

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: 11 June 2015 17:12
To: Oracle Mailing List
Subject: Log file sync waits

Does anyone have a query that will allow me to track the history of log file sync times? We hit a big slow up today and I am trying to track the history to see when it started.

Sent from my iPhone--
http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 11 2015 - 17:26:36 CEST