Resource Plan Directives

This 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 9i

With 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:

ColumnDescription
SessSpecifies maximum number of concurrently active sessions for a consumer group
QueueSpecified time (in seconds) after which a job in the execution queue (waiting for execution) will timeout
SwGrpSpecifies consumer group to which this session is switched if other switch criteria is met
SwTimeSpecifies time (in seconds) that a session can execute before it is switched to another consumer group
SesTOSpecifies the maximum execution time (in seconds) allowed for a session
UndoSets a maximum in kilobytes (K) on the total amount of undo generated by a consumer group

More information

For more detailed information on Resource Plans, see the documentation shipped with your Oracle Database software in the chapter on "Using the Database Resource Manager".