Figure 8-14 shows both the log writer background process IO targeted script and the output. The script accepts the reporting interval as an argument and reports only log writer background process write statistics. Figure 8-15 shows a sample output from a system experiencing severe log file parallel write waits.

Figure 8-14. Shown is a simple log writer background process IO script that will produce both IO operations per second (IOPS) and MB/s. The script takes a single argument of the interval gathering time.

Figure 8-15. Shown is the output from the script shown in Figure 8-14 with a gathering interval of 60 seconds. During the 1-minute interval, on average, the log writer wrote 1.6 IO operations each second, or 1.6 IOPS, and it wrote an average of 4.070 MB/s.