Let’s look at some statspack data from an OLTP Order Entry benchmark run that achieved 133 transaction per second (TPS): Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time —————————————– ———— ———– —— —— log file sync 68,965 1,117 16 64.6 db file sequential read 159,712 241 2 14.0 … Continue reading Manly Men Only Use Solid State Disk For Redo Logging. LGWR I/O is Simple, But Not LGWR Processing