select * from V$TRXWAIT ; # select id "被阻塞事物ID",wait_for_id "阻塞者事物ID",wait_time "等待时间" from v$trxwait;
SELECT SESS_ID,SQL_TEXT,TRX_ID,THRD_ID from V$SESSIONS where TRX_ID=57223;
SP_CLOSE_SESSION(SESS_ID); 关闭会话
当dm.ini中的参数ENABLE_MONITOR=1时，使用死锁历史动态试图V$DEADLOCK_HISTORY，可以查询到发生过的死锁信息。
select * from V$DEADLOCK_HISTORY;
