Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER, 13 of 19
This procedure lets you make changes to resource manager objects.
All changes to the plan schema must be done within a pending area. The pending area can be thought of as a "scratch" area for plan schema changes. The administrator creates this pending area, makes changes as necessary, possibly validates these changes, and only when the submit is completed do these changes become active.
You may, at any time while the pending area is active, view the current plan schema with your changes by selecting from the appropriate user views.
At any time, you may clear the pending area if you want to stop the current changes. You may also call the VALIDATE
procedure to confirm whether the changes you has made are valid. You do not have to do your changes in a given order to maintain a consistent group of entries. These checks are also implicitly done when the pending area is submitted.
DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;
The following rules must be adhered to, and they are checked whenever the validate or submit procedures are executed:
parallel_degree_limit_p1
, may only appear in plan directives that refer to consumer groups (i.e., not at subplans).
OTHER_GROUPS
somewhere in any active plan schema.This ensures that a session not covered by the currently active plan is allocated resources as specified by the OTHER_GROUPS
directive.
If any of the above rules are broken when checked by the VALIDATE
or SUBMIT
procedures, then an informative error message is returned. You may then make changes to fix the problem(s) and reissue the validate or submit procedures.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|