1.查看锁表进程的sql
select t2.OBJECT_ID,c.OBJECT_NAME,t1.* from v$session t1, v$locked_object t2,all_objects c where t1.sid = t2.SESSION_ID and c.OBJECT_ID = t2.OBJECT_ID;
2.杀掉进程的sql
alter system kill session '36,16321';
36是指sid ,16321是指serial#
1.查看锁表进程的sql
select t2.OBJECT_ID,c.OBJECT_NAME,t1.* from v$session t1, v$locked_object t2,all_objects c where t1.sid = t2.SESSION_ID and c.OBJECT_ID = t2.OBJECT_ID;
2.杀掉进程的sql
alter system kill session '36,16321';
36是指sid ,16321是指serial#