RE: Log file sync waits

From: Luca Canali <>
Date: Thu, 11 Jun 2015 15:26:36 +0000
Message-ID: <>

Hi Andrew,

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: 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.


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

From: [] 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--

-- Received on Thu Jun 11 2015 - 17:26:36 CEST

Original text of this message