首页数据库 Oracle oracle 解锁语句

oracle 解锁语句

dawei 2020年7月3日 4:07

SELECT alter system kill session ||s.sid||,||s.serial#||;,s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine, s.terminal, s.logon_time, l.type FROM v$session s, v$loc

SELECT 'alter system kill session '''||s.sid||','||s.serial#||''';',s.sid,s.serial#,s.username,s.schemaname,s.osuser,s.process,s.machine,s.terminal,s.logon_time,l.type FROM v$session s,v$lock l WHERE s.sid = l.sid AND s.username IS NOT NULL ORDER BY sid;