How to Find the Session Holding Lock on the Object being tested at Unit Test Of SQL Developer Which shows Unable to Obtain Lock At This Time
(Doc ID 2631449.1)
Last updated on JULY 20, 2021
Applies to:Oracle SQL Developer - Version 18.2 and later
Information in this document applies to any platform.
You are trying to test a procedure ( say PROCEDURE1) using Unit Test at SQL Developer and getting following message
This message is an indication that some other user has locked that specific Object for test which you are trying to test at unit testing.
You would like to know the session which has locked object so that you can clear that session and proceed with testing.
For the Demonstration purpose Following has been considered as sample for better understanding.
UT_USER - is the schema user which owns the Unit Test Repository
PROCEDURE1 - Is the Object with the Lock.
WS1 - Workstation1 connected as UT_USER
WS2 - Workstation2 connected as UT_USER
WS2 has session ID 65 which has locked PROCEDURE1 and WS1 is trying to Lock same PROCEDURE1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document