Oracle 锁问题
Oracle 锁问题
一、出现阻塞解决方法
1、找出那些用户在阻塞
- select sid,serial#,username from v$session where sid in (select blocking_session from v$session);
2、杀掉用户所在的进程
- alter system kill session '&sid,&serial' immediate;
--3、找出航和表锁
- select sid,id1,id2,lmode,request,ctime,block from v$lock where type in('TM','TX');
--4、找出用户
- select owner,object_name from dba_object where object_id in(id1,id2);
- select sid,serial#,username from v$session where sid in (
- select sid from v$lock where type in('TM','TX')
- );
5、杀掉进程
- alter system kill session '&sid,&serial' immediate;
评论暂时关闭