--運(yùn)行詞句檢查是否有鎖表

select object_name, machine, s.sid, s.serial#,s.LOGON_TIME
from vsession s
where l.object_id = o.object_id
and l.session_id = s.sid;

--運(yùn)行此句生成解鎖表語(yǔ)句

select 'alter system kill session '''||''||s.sid||','||s.serial#||''';'
from vsession s
where l.object_id = o.object_id
and l.session_id = s.sid;

--運(yùn)行生成的語(yǔ)句就可以了