General | ||||||||||||||||||||||||||||||||||
Note: Resource Manager requires a massive over-demand on CPU before the expected behavior starts to show: Generally speaking a 300% or 400% CPU load to see that the actual split gets closer to expectation, with the lower-privileged processes losing time in a wait state whose name includes 'resmgr: ....{something}..' | ||||||||||||||||||||||||||||||||||
Source | {ORACLE_HOME}/rdbms/admin/dbmsrmad.sql | |||||||||||||||||||||||||||||||||
First Available | 8.1.5 | |||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||
|
CLEAR_PENDING_AREA | |
Clears the work area for the resource manager | dbms_resource_manager.clear_pending_area; |
exec dbms_resource_manager.clear_pending_area ; |
CREATE_PENDING_AREA | |
Creates a work area for changes to resource manager objects | dbms_resource_manager.create_pending_area; |
See Demo |
DELETE_CONSUMER_GROUP | |
Delete entries that define resource consumer groups | dbms_resource_manager.delete_consumer_group(consumer_group IN VARCHAR2); |
See Demo | |
| |
DELETE_PLAN | |
Deletes the specified plan as well as all the plan directives to which it refers | dbms_resource_manager.delete_plan(plan IN VARCHAR2); |
exec dbms_resource_manager.delete_plan ('UW_PLAN'); | |
| |
DELETE_PLAN_CASCADE | |
Deletes the specified plan as well as well as its descendants (plan directives, subplans, consumer groups) | dbms_resource_manager.delete_plan_cascade(plan IN VARCHAR2); |
See Demo | |
| |
DELETE_PLAN_DIRECTIVE | |
Delete resource plan directives | dbms_resource_manager.delete_plan_directive( |
See Demo | |
| |
SET_CONSUMER_GROUP_MAPPING | |
Adds, deletes, or modifies entries that map sessions to consumer groups, based on the session's login and runtime attributes | dbms_resource_manager.set_consumer_group_mapping( |
TBD | |
| |
SET_CONSUMER_GROUP_MAPPING_PRI | |
| dbms_resource_manager.set_consumer_group_mapping_pri( |
desc dba_rsrc_mapping_priority | |
| |
SET_INITIAL_CONSUMER_GROUP | |
Assigns the initial resource consumer group for a user: Obsolete | dbms_resource_manager.set_initial_consumer_group( |
Deprecated | |
| |
SUBMIT_PENDING_AREA | |
Submits pending changes for the resource manager | dbms_resource_manager.submit_pending_area; |
See Demo | |
| |
SWITCH_CONSUMER_GROUP_FOR_SESS | |
| dbms_resource_manager.switch_consumer_group_for_sess( |
SELECT username, initial_rsrc_consumer_group | |
| |
SWITCH_CONSUMER_GROUP_FOR_USER | |
Changes the resource consumer group for all sessions with a given user name | dbms_resource_manager.switch_consumer_group_for_user( |
exec dbms_resource_manager.switch_consumer_group_for_user ( | |
| |
SWITCH_PLAN | |
Sets the current resource manager plan | dbms_resource_manager.switch_plan( |
TBD |
VALIDATE_PENDING_AREA | |
Validates pending changes for the resource manager | dbms_resource_manager.validate_pending_area; |
See Demo | |
| |
Demos | |
| conn / as sysdba |
| /* |
| conn / as sysdba |
参考至:http://hi.baidu.com/edeed/blog/item/33c6b901c36b3a07728da521.html
如有错误,欢迎指正
邮箱:czmcj@163.com