查看被锁定的对象

纵横四海

select v.object_id, v.session_id SID, v.oracle_username , v.os_user_name
from v$locked_object v, v$lock l
where l.sid=v.session_id
and l.block > 0

***************************************************
Note 166924.1 - Ora-04020 Deadlocks Most Common Causes
Note 164661.1 - Ora-60 And Deadlocks Most Common Causes
Note 132629.1 - How to know which row is locked by what user.
***********************************************