ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle pending area

Oracle pending area

原创 Linux操作系统 作者:keeptrying 时间:2012-06-05 13:47:42 0 删除 编辑

If you do not use Enterprise Manager to create the resource plan or resource consumer groups,you must first create a pending area.

The first thing you must do to create or modify plan schemas is to create a pending area.This is a scratch area allowing you to stage your changes and to validate the before they are made active.

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" all existing, or active, plan schemas into the pending area so that they can be updated or new plans added. Active plan schemas are those schemas already stored in the data dictionary for use by the Database Resource Manager. If you attempt to update a plan or add a new plan without first activating (creating) the pending area, you will receive an error message notifying you that the pending area is not active.

ORA-29371: pending area is not active

Cause: An attempt was made to make changes without creating a pending area.

Action: Invoke procedure CREATE_PENDING_AREA before making any changes.

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25744374/viewspace-731953/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-25

  • 博文量
    130
  • 访问量
    909104