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@xxxxxxxxx> 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--
//www.freelists.org/webpage/oracle-l
