This figure illustrates the multilevel schema created by the example in the text.

There are three plans. MYDB_PLAN is the top level plan, MAILDB_PLAN and BUGDB_PLAN are subplans of MYDB_PLAN. MAILDB_PLAN receives 30 percent of the CPU at level 1, and BUGDB_PLAN receives 70 percent at level 1.



There are three groups (and the mandatory OTHER_GROUPS) that consume resources in MAILDB_PLAN. MAIL_POSTMAN_GROUP receives 40% of the CPU at level 1, MAIL_USERS_GROUP receives 80% of the CPU at level 2, and MAIL_MAINTENANCE_GROUP receives 20 percent of the CPU at level 2. OTHER_GROUPS receives 100 percent of the CPU at level 3.

There are also three groups (and the mandatory OTHER_GROUPS) that consume resources in the BUGDB_PLAN. The BUG_ONLINE_GROUP receives 80 percent of the resources at level 1, the BUG_BATCH_GROUP receives 20 percent of the resources at level 1, and the BUG_MAINTENANCE_GROUP receives 100 percent of the resources at level 2. OTHER_GROUPS receives 100 percent of the CPU at level 3.