请根据实际情况进行参与引用。
(1)查询死锁进程
select A.SID,b.serial#,c.object_name,b.username,b.machine,b.program
from v$lock a,v$session b,all_objects c
where a.sid=b.sid and a.type in ('TM','TX')
and c.object_id=a.id1
order by username ;
(2)kill进程
--kill 该进程
alter system kill session 'SID,serial#';
(3)账户被锁定的解决
the account is locked
解决办法--系统管理员执行---ALTER USER username ACCOUNT UNLOCK;