Please pour in your opinions. There seems to be lots of locks occuring with this table . What do I do when a table is locked ?
I think you need to consult your application developers. They
should avoid higher level locking unless extremely critical to design. If they do use high level locking, they should set up processes so that they acquire locks in the same order.
And can you please tell me how to come out of a deadlock and how to prevent it. The last time it happened, I had to ask everyone to log out and restarted the db.
To come out of the deadlock, unfortunately, you have to terminate the user processes contending for the lock.
Identify the holding sessions and terminate them using Alter System Kill session.