Table lock from oem

How to find Table Lock in 11g from Oracle Enterprise Manager

Login OEM

user_id- *****

password- ****

 

1. OEM HOME PAGE (11g grid control )

 2. Click on Performance tab (just like on pic)

go down find INSTANCE LOCKS Link (on pic 2nd row top). 

Click on it.

 3. In Instance lock ling

Change View-<All Instance Locks>

just like pic.

After that you got object Name list what about locks table.

If any table name present in this row that means its a locking table table name.

Find SID and Unblock it as well as kill it also.

**************************END******************************