Database Administration (MOSC)

MOSC Banner

Does DBMS_RESOURCE_MANAGER have locking mechanism?

edited Feb 21, 2014 12:00PM in Database Administration (MOSC) 12 commentsAnswered

Hi, My Oracle DB is version 11gR2 running on windows server 2003. My JDBC application is deployed in a clustered system that multiple operation can be performed on the same target at the same time. One typical operation is to set/modify consumer group.

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 sometimes, not always, failed with the following error message:

ORA-29370: pending area is already active

ORA-06512: at "SYS.DBMS_RMIN", line 434

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center