1. 查询当前是否有锁住其它会话的锁: select * from v$lock where block<>0; 2.查询当前正在等待加锁(被锁)的会话: select * from v$lock where request<>0;