Hello DBAs:

How do I query v$lock for dead lock detection?

I can look for a trace file and its components by looking at alert_log that we have a deadlock, but otherwise ...

Thanks, ST2000