Oracle锁表处理方式介绍

1

2

3

select b.owner,b.object_name,a.session_id,a.locked_mode

from v$locked_object a,dba_objects b

where b.object_id = a.object_id

1

2

3

4

5

select a.OS_USER_NAME, c.owner, c.object_name, b.sid, b.serial#, logon_time

  from v$locked_object a, v$session b, dba_objects c

 where a.session_id = b.sid

   and a.object_id = c.object_id

 order by b.logon_time;

1

2

-- immediate 添加为立即结束

alter system kill session 'sid,serial' immediate

1

GRANT ALTER SYSTEM TO <username>;

1

select a.SID,a.USERNAME,a.status,a.process,b.SPID from v$session a,v$process b where a.PADDR=b.ADDR;

1

kill -9 进程号

1

orakill sid spid