Re: Log file sync waits

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Fri, 12 Jun 2015 16:45:31 -0500
Message-ID: <CA+fnDAYj6_1Uao1qmhjTL7JAzivNCgY+sJYj_nn2LvouYYxFYQ_at_mail.gmail.com>

andrew - try this, personally i think it beats any other suggestions here for log file sync specifically... :)

https://github.com/fidelinho/SAP_Note_1438410_V49/blob/master/SystemStatistics_LGWR.txt

report columns:
- REDO_GB/H

• WRITES/S
• KB/WRITE
• MS/WRT_REQ
• WRT_MB/S
• WRT_BUSY_%
• SYNCS/S
• MS/SYNC
• SYNC_SESS
• COMMITS/S

--
http://about.me/jeremy_schneider


On Thu, Jun 11, 2015 at 10:11 AM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
> 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 Fri Jun 12 2015 - 23:45:31 CEST