查找死锁表及对应的Session

select a.object_name, b.*
from all_objects a,
     v$locked_object b
where a.object_id=b.object_id