How to find locks on my database using Spotliglht on Oracle
In Spotlight, you will see a Lock Wait alarm on the Spotlight Home page
Right click the alarm and select "Show Details | Activity Locks"
The Activity drill down will display all locking information including Blocking Locks which are displayed on the Blocking Locks tab
You can test this by issuing the following sql in two separate sessions:
Session 1:
select empno
from emp for update of empno;
Session 2:
update emp set ename = 'Miller'
where empno = 7369;
