Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle deadlock detection script

446045Jan 15 2008 — edited Jan 16 2008

Hi All,
I have found lots of deadlock in alert and trace files. So I want to write a script that would detect deadlocks when occur and save both user info/SQL statements as a output in text file.

Can anyone help regarding this.
Thanks in Advance.
SAN

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 15 2008

#general-database-discussions

13 comments

3,751 views