Oracle资源正忙，杀进程语句

–找到锁住的那条数据的session_id

select * from v$locked_object;--找到session_id='766'

–找到sid='766’的那条数据，找出它的serial#的值

select * from v$session where sid='766';--找到serial#='44891'

–杀掉长期未释放的锁 alter system kill session ‘sid,serial#’;

alter SYSTEM kill session '766,44891';