Plan

Now that we have some background about Resource Manager, let's look at an example scenario. Like most successful actions, let's start by making a plan. In this case, it's a Resource Manager's plan. Here, we define how resources are divided among the different users or processes. We will also make a plan with room for administrative users (the DBA has to solve problems), normal online users, and the four classes of batches. Each class will have a maximum or total resource usage allocated to it. This means that the low-impact class can have more jobs running than those in the heavy-impact class. For some jobs, it does not make sense to start when all the resources that the job needs are not available. For instance, a report needs to be run that performs excellently when using 64 pq slaves, but becomes a nightmare when it runs on only four slaves. It will clearly be better to wait for the resources instead of starting on time. Entering a Resource Manager plan on the command line is...