Oracle 用户被锁解决方案

一、先查询用户的session会话。

二、kill语句杀掉被锁进程（必须使用immediate语句，立即释放资源）。

语句：

select o.object_type,

o.object_name,

l.OS_USER_NAME,

l.ORACLE_USERNAME,

'session' v_$session,

s.*,

'lock' locked_object,

l.*,

'object' objects,

o.*

from sys.v_$locked_object l, sys.all_objects o, sys.v_$session s

where l.OBJECT_ID = o.object_id

and l.SESSION_ID = s.SID

order by o.object_type, o.object_name;

select t2.username, t2.sid, t2.serial#, t2.logon_time

from v$locked_object t1, v$session t2

where t1.session_id = t2.sid

order by t2.logon_time;

alter system kill session '151,45159' immediate;