Oracle数据库中，Pending Area是进行资源管理计划更改的关键。在创建消费者组时，必须先创建Pending Area以避免错误。Pending Area的创建、验证、提交和清除是其管理的四个步骤。验证过程确保变更符合特定规则，如避免循环、保证百分比不超过100%等。提交变更前需通过validate验证，然后使用submit使其生效。若要清除Pending Area，需调用DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA，以便进行新的更改。
92. You want to create a consumer group, GROUP1, and you execute the following command in the
commandline
interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP =>'group1', COMMENT => 'New Group');
This command errors out displaying the following message:
ERROR at line 1:
ORA29371:
pending area is not active
ORA06512:
at "SYS.DBMS_RMIN", line 115
ORA06512:
at "SYS.DBMS_RESOURCE_MANAGER", line 108
ORA06512:
at line 1
What action would you take to overcome this error?
A.create the Pending Area before creating the consumer group
B.activate the Pending Area before creating the consumer group
C.increase the size of the large pool to accommodate the Pending Area
D.increase the size of the shared pool to accommodate the Pending Area
E.increase the size of the database buffer cache to accommodate the Pending Area
Answer: A
Creating a Pending Area
To create a pending area, you use the following statement:
EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;
In effect, you are making the pending area active and "loading&
最低0.47元/天 解锁文章
扫一扫
2353
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
