Oracle 创建资源计划

最新推荐文章于 2022-01-27 10:56:12 发布

转载最新推荐文章于 2022-01-27 10:56:12 发布 · 1.5k 阅读

oracle_optimize 同时被 2 个专栏收录

65 篇文章

订阅专栏

job_resource

3 篇文章

订阅专栏

本文介绍如何在Oracle数据库中创建资源管理器的未决区、资源消费组、资源计划及计划指示，并验证及提交更改，最后将用户分配到指定的消费组。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 创建未决区

DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;

2.创建资源消费组

DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP => 'rudy01_consumer_group',
COMMENT => 'this is rudy test consumer group');
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP => 'rudy02_consumer_group',
COMMENT => 'this is rudy test consumer group');
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP => 'rudy03_consumer_group',
COMMENT => 'this is rudy test consumer group');

3.创建资源计划

DBMS_RESOURCE_MANAGER.CREATE_PLAN(PLAN => 'rudy_membership_plan',
CPU_MTH => 'RATIO',
COMMENT => 'this is a plan');

4.创建计划指示

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN => 'rudy_membership_plan',
GROUP_OR_SUBPLAN => 'rudy01_consumer_group',
COMMENT => 'this is a test plan directive',
CPU_P1 => 40);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN => 'rudy_membership_plan',
GROUP_OR_SUBPLAN => 'rudy02_consumer_group',
COMMENT => 'this is a test plan directive',
CPU_P1 => 30);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN => 'rudy_membership_plan',
GROUP_OR_SUBPLAN => 'rudy03_consumer_group',
COMMENT => 'this is a test plan directive',
CPU_P1 => 30);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN => 'rudy_membership_plan',
GROUP_OR_SUBPLAN => 'other_groups',
COMMENT => 'this is a test plan directive',
CPU_P1 => 0);

--注意如果你的电脑是单核cpu，就不要使用CPU_P2了，不然会报错

5.验证未决区

DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA;

6.提交未决区

DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

7.指派用户到消费组

DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(GRANTEE_NAME => 'scott',
CONSUMER_GROUP => 'rudy01_consumer_group',
GRANT_OPTION => TRUE);
DBMS_RESOURCE_MANAGER.SET_INITIAL_CONSUMER_GROUP(USER => 'scott',
CONSUMER_GROUP => 'rudy01_consumer_group');