Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to resolve locking situations?

April 26, 2017locking resolve situations

0

Posted

How to resolve locking situations?

1 Answer

0

Posted

Most locking issues are application specifics. To resolve locking contention, one needs to free the resource by: a. Asking the HOLDER to commit or rollback, b. Killing the session which holds the lock, eg ALTER SESSION KILL SESSION sid, serial #; c. If the database is running on unix or vms, it is possible to kill the unix / vms shadow process directly. It is not recommended. When killing the unix / vms shadow process, please be careful of shared servers in a multi-threaded environment. d. ROLLBACK FORCE or COMMIT FORCE if 2pc pending transaction.