Database Administration (MOSC)

MOSC Banner

Blocking locks - managing

edited Nov 10, 2015 10:12AM in Database Administration (MOSC) 3 commentsAnswered

We have a 2-node and 3-cluster 11r2g system and are using streams. Currently a problem has come up that has caused blocking locks on one node that we have a particular process running on. The locks have occurred only recently and three times in one and half weeks. I know the table the dml blocking locks are occurring and after I kill the blocking locks all goes back to normal. We have looked at the application/process code that updates that table but haven't figured it out yet. Could you use an hourly job to auto kill any blocking locks outstanding

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