Database - RAC/Scalability (MOSC)

MOSC Banner

Is the use of the DBMS_LOCK package compatible with RAC

edited Mar 12, 2009 5:07AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered
In an attempt to control object locking in a more refined way and implement shared row locking I changed my data manipulation APIs to use the DBMS_LOCK package.  This gave me more fine-grained control over locking and while it did indeed improve the throughput in terms of concurrent operations and minimized locked out scenarios, performance began to significantly degrade as the number of the allocated locks increased. I encountered two serious problems (exponential degradation of performance if a large number of locks are held per session and the explosive growth of the DBMS_LOCK_ALLOCATED table) that I was able to workaround but I am concerned that it is not the best way to implement the shared row locking behavior I require. I have a few questions:

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