--查看被锁的表 select b.owner, b.object_name, a.session_id, a.locked_mode from v$locked_object a, dba_objects b where b.object_id = a.object_id; -- 杀掉session ,立即释放资源 alter system kill session 'sid,serial#' immediate; -- 杀掉session,非立即释放资源,如果一个更新或查询执行时间特别长,不建议使用此方式 alter system kill session '1576,13739'; -- 生成kill session 语句 select s.USERNAME, 'alter system kill session '||''''||S.sid|| ','||S.serial#||'''' || ';', 'kill -9 ' || p.SPID, s.STATUS, s.SQL_ID, s.STATE, s.EVENT, s.MACHINE, sq.SQL_TEXT from v$session s, v$sqlarea sq, v$process p where s.PADDR = p.ADDR and s.SQL_ID = sq.SQL_ID(+) AND S.STATUS='ACTIVE' --and s.SID = 449 and s.USERNAME ='PKUFI_ODS'; --and s.EVENT like '%db file sequential read%' |
Archiver|知识站 ( 鲁ICP备20004068号-1 )
GMT+8, 2020-6-23 22:50 , Processed in 0.015365 second(s), 17 queries .