查询发生死锁的select语句
select sql_text from v$sql where hash_value in (select sql_hash_value from v$session where sid in(select session_id from v$locked_object))
---------------------------------------------------------关于数据库死锁的检查方法
一、...(more)
锁主要分为两类:读锁和写锁
===================================锁等待分析#制造场景事务1事务2update employee set bonus=salary*0.1 where job='MANAGER';update employee set salary=salary*0.02;
select salary,bonus from employee where job='MANAGER'select job ...(more)