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******************************


No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...