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 |
Consumer Group Mapping Constants
| |
Consumer Group Mapping Constants
|
Name | Data Type | Value |
client_machine | VARCHAR2(30) | 'CLIENT_MACHINE' |
client_os_user | VARCHAR2(30) | 'CLIENT_OS_USER' |
client_program | VARCHAR2(30) | 'CLIENT_PROGRAM' |
module_name | VARCHAR2(30) | 'MODULE_NAME' |
module_name_action | VARCHAR2(30) | 'MODULE_NAME_ACTION' |
oracle_user | VARCHAR2(30) | 'ORACLE_USER' |
performance_class | VARCHAR2(30) | 'PERFORMANCE_CLASS' |
service_module | VARCHAR2(30) | 'SERVICE_MODULE' |
service_module_action | VARCHAR2(30) | 'SERVICE_MODULE_ACTION' |
service_name | VARCHAR2(30) | 'SERVICE_NAME' |
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 | |
| |
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 | |
Creates the session attribute mapping priority list | 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 | |
Changes the resource consumer group of a specific session | 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 | |
Create Plan 1 Demonstration | conn / as sysdba |
Create Plan 2 Demonstration | /* |
Drop Plan Demonstration | conn / as sysdba |
如有错误,欢迎指正