–查询被锁住的数据库对象
SELECT b.object_name, machine, c.sid, c.serial#, b.status, d.pid, d.spid, d.addr FROM gv$locked_object a, dba_objects b, gv$session c, v$process d WHERE a.object_id = b.object_id AND a.session_id = c.sid AND d.addr = c.paddr;
–杀死数据库会话
alter system kill session '207,707'; – 207为SID, 707为SERIAL#
–查询当前操作的系统进程ID
select spid, osuser, s.program from v$session s, v$process p where s.paddr = p.addr and s.sid = 207; -- 207为SID
kill -9 24664 // 24664为UNIX/LINUX系统进程ID
发表评论(对文章涉及的知识点还有疑问,可以在这里留言,老高看到后会及时回复的。)