Oracle数据库常用脚本
SELECT s.sid, s.serial
ALTER system KILL session '693,37361';
select 'alter system kill session '''||s.sid ||','||s.SERIAL#||'''IMMEDIATE;' from v$locked_object lo, dba_objects ao, v$session s WHERE ao.object_id = lo.object_id AND lo.session_id = s.sid;
SELECT s.username, l.type, decode(l.type,'TM','TABLE LOCK', 'TX','ROW LOCK', NULL) LOCK_LEVEL, o.owner,o.object_name,o.object_type, s.sid,s.serial
FROM v$session s,v$lock l,dba_objects o
WHERE l.sid = s.sid AND l.id1 = o.object_id(+) AND s.username is NOT NULL and decode(l.type,'TM','TABLE LOCK', 'TX','ROW LOCK', NULL) is not null
order by l.type;
select * from pro