How to find locks on my database with Spotlight on Oracle (4293455)

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;