oracle添加栏位

给大表添加栏位时遇到表有死锁而添加失败，需要kill掉死锁进程

1.先查SID和serial# 

SELECT object_name, machine, s.sid, l.SESSION_ID,s.serial#FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid order by object_name,l.SESSION_ID 

对应语句中 l.SESSION_ID,s.serial

2杀掉进程

alter system kill session '1146,45487' IMMEDIATE;

不加IMMEDIATE有可能执行不了，杀不掉

另外添加栏位时如果有对表操作的事务正在运行，也可能添加失败，没试过，待考证