Resource Plan DirectivesThis table lists up the resource plan directives for consumer groups only. Although most column names are self-explaining, one word on the CPU columns: Within one plan, first the group with Prio 1 is served and receives all CPU it needs up to the percentage set in this column. From the leftover, the same procedure is repeated for Prio 2 and so on. This means, all values for a given plan and a given Prio should sum up to max. 100, while the value for a given plan and all Prios can (and in most cases should) sum up to more than 100. New columns with Oracle 9iWith Oracle 9i, this facility improved and new capabilities have been added. As a result, there are some more columns available and displayed by OraRep for Oracle Databases version 9 and up:
More informationFor more detailed information on Resource Plans, see the documentation shipped with your Oracle Database software in the chapter on "Using the Database Resource Manager". |