How To – Find the locking object and release object lock
Many time we faced the performance issue because of Locks on rows and it cause the delay to finishing the other transactions. So with the help of following steps you will able to find the locking objects and can release the object locks in Oracle Database. Let us create the example to understand clearly Terminal – 1 Step -1: Here we have execute the Update Statement in the SCOTT Schema without Commit Terminal – 2 Step -2: Now we try
» Read more