Workload management can provide arguably the most elegant of all performance improvements. And of all the missed performance-improving opportunities, I would say better workload management has got to be near the top. While shifting workloads may not be a very satisfying technical challenge (though it can be), when the workload is better managed, peak workload and painful performance periods can be dramatically improved. And all this can occur without tuning Oracle, the application, or the operating system, and without any capital investment.

Suppose around time 13 in Figure 9-19 is when users are extremely upset. It's not time 23, because the users are asleep and the batch jobs are running just fine. The performance analyst must determine what is occurring-that is, the workload mix-during time 13 and work with the user community to shift a segment of that workload, perhaps to time 15. While this may seem unlikely, when confronted with a severe performance problem, a graphic clearly showing the situation (for example, Figure 9-19), users can be surprisingly flexible. But if they are told to change the way they work without understanding why, they will most likely rebuff any attempt to alter the workload.

Figure 9-19. Shown is a workload graph, which appears to have ample workload-balancing opportunities. By moving some of the workload during painful peak processing time to nonpeak processing times, the workload requirements during peak times are effectively reduced. This decreases response time, allows for increased workload of a specified type, or some combination of both.