oracle-table is locked

1. If you update a table, without an error, waiting for a long time is not over, it is likely that the table is locked.

2. View Locked objects

Select sid,serial#,username,schemaname,osuser,machine,terminal,program,owner,object_name, Object_type,o.object_id from dba_objects o,v$locked_object l,v$session swhere o. object_id =L.object_id and S.sid=l.session_id;  

3. The session that killed inactive's lock list

Alter system kill session ' sid,serial# ';

Alter Kill ' 491,47198 ';

4. View the current session

SELECT * from V$mystat where rownum = 1

Transferred from: http://blog.163.com/liyani_1980/blog/static/38604145201351033139921/

oracle-table is locked