oracle 解锁表

oracle 解锁表步骤：
1：查看被锁的表

SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID
  FROM ALL_OBJECTS A, V$LOCKED_OBJECT V
WHERE A.OBJECT_ID = V.OBJECT_ID 

2:查看锁

SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID
  FROM ALL_OBJECTS A, V$LOCKED_OBJECT V
WHERE A.OBJECT_ID = V.OBJECT_ID 

2、杀死锁

--alter system kill session 'sid,serial#';
alter system kill session '156,87';--查看表大小