Issues with pending area
Hi, I'm new to the Oracle Database and I just ran into some issues with resource plan. My DB version is 11gR2 running on windows server 2003.
Based on the documentation at http://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm003.htm, I tried to execute the following:
BEGIN
DBMS_RESOURCE_MANAGER.clear_pending_area;
DBMS_RESOURCE_MANAGER.create_pending_area;
dbms_resource_manager.set_initial_consumer_group(user => 'TESTER1'
,consumer_group => 'DSS_GROUP');
DBMS_RESOURCE_MANAGER.validate_pending_area;
DBMS_RESOURCE_MANAGER.submit_pending_area;
END;
It failed with the following error message:
ORA-29370: pending area is already active
Based on the documentation at http://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm003.htm, I tried to execute the following:
BEGIN
DBMS_RESOURCE_MANAGER.clear_pending_area;
DBMS_RESOURCE_MANAGER.create_pending_area;
dbms_resource_manager.set_initial_consumer_group(user => 'TESTER1'
,consumer_group => 'DSS_GROUP');
DBMS_RESOURCE_MANAGER.validate_pending_area;
DBMS_RESOURCE_MANAGER.submit_pending_area;
END;
It failed with the following error message:
ORA-29370: pending area is already active
0