在sqlplus下，如何看数据库中有没有死锁？

[hutiefeng9847]

在sqlplus下，如何看数据库中有没有死锁？

['Alan]

建一死视图：
create view locked_object as select object_name,machine,spid,ctime from all_objects,v$lock,v$locked_object,v$session,
v$process where all_objects.object_id=v$locked_object.object_id and v$process.addr=v$session.paddr
and v$lock.sid=v$session.sid and v$locked_object.session_id=v$session.sid


select * from locked_object ;

[pianer]

select * from v$lock; (不包括DDL锁)

[yellowzhong]

Good;