-----查询一个被锁定的session
SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID FROM ALL_OBJECTS A, V$LOCKED_OBJECT V WHERE A.OBJECT_ID = V.OBJECT_ID AND A.OBJECT_NAME LIKE 'FM_SYS_FUNCTION%';
-----同过上个表的查询 可以得到一个session_id
select * from v$session a where a.seseion_id = '';
----然后kill掉
alter system kill session ' sid ,serial# ' ;
alter system kill session '150,839';
select a.* from v$session a;