Page History

...

In the above DB Optimizer screen, the same workload was run 4 ran four times. We can see that the time (width of the load) reduced, and the percent of activity on CPU increased.

Runs:

1. In Run 1, the orange "log file sync" , the orange color, area is the biggest color arealargest, which means uses are waiting on commits , still even though we are committing less in the code. In this case we moved the log files to a faster device. You can see the checkpoint activity just after run 1 where we moved the log files.
2. In Run 2, the dark red "buffer busy wait" , the burnt red, area is the biggest color arealargest. We drilled down on the buffer busy wait event in the Top Event section and the details tell us to move the table from a normal tablespace to an Automatic Segment Space Managed tablespace.
3. In Run 3, the dark brown "log file switch (checkpoint incomplete)" , the dark brown, are is the largest color area, so we increased the size of the log files. ( You can see the IO time spent creating the new redo logs just after run Run 3.)The  The run time is the shortest and all the time is spent on the CPU which was our goal, to take advantage of all the processors and run the batch job as quickly as possible.

...