查找死锁
select sql_text,s.sid,s.SERIAL# from v$sql sql inner join v$session s on sql.hash_value=s.sql_hash_value
where sid in (select session_id from v$locked_object)
查找死锁
select sql_text,s.sid,s.SERIAL# from v$sql sql inner join v$session s on sql.hash_value=s.sql_hash_value
where sid in (select session_id from v$locked_object)