oracle查找被锁以及解锁
SELECT ssid||||sSERIAL# sserial# susername sschemaname sosuser sprocess smachine
sterminal slogon_time ltype
FROM v$session s v$lock l
where ((ssid = lsid
AND susername IS NOT NULL))
and
(terminal = CHINACEE)
alter system kill session ;
第一条sql是找出被锁第二条解锁
