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!

Deadlock troubleshooting

user13117585Jan 9 2012 — edited Jan 9 2012

Hi eveyone,

I have a question about deadlocks. We had a huge problem and it seems to be related to deadlocks. Unfortunately, the database has beed restarted and we can't find the blocking session.

I have received some trace files (that were in udump folder) and I was wondering if anyone can advise on how I can get some info from these files.

Is there any other log file in Oracle that can help me?

I'm using Oracle 10g.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2012

Added on Jan 9 2012

#general-database-discussions

6 comments

1,145 views