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;