察看死锁 select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode from v$locked_object lo,dba_objects ao,v$session sess where ao.object_i...
包括waiting for a lock和running的事务 select * from information_schema.innodb_trx ``第二步,kill进程 show engin innodb status; //最后一次死锁信息及sql show open tables where in_use > 0 /...