1、查询当前是否存在锁
SQL> select o.name,l.* from v$lock l,sysobjects o where l.table_id=o.id and blocked=1;
2、select * from v$trxwait;
其中ID请求的会话被WAIT_FOR_ID占用锁住
3、查询占用锁的SQL
select SQL_ID,SESS_ID,TRX_ID from v$sql_history where trx_id=217662;
4、杀会话
sp_close_session(95677440);
1、查询当前是否存在锁
SQL> select o.name,l.* from v$lock l,sysobjects o where l.table_id=o.id and blocked=1;
2、select * from v$trxwait;
其中ID请求的会话被WAIT_FOR_ID占用锁住
3、查询占用锁的SQL
select SQL_ID,SESS_ID,TRX_ID from v$sql_history where trx_id=217662;
4、杀会话
sp_close_session(95677440);