Hi Sachin:
In the trace files you mentioned should be the SQLs involved in the deadlock as the rowid of the records locked.
This is your point of start.
Regards
Alfonso Leon
hi
problem is that , Database stop respone to application Server but still it is giving response to Toad and others things .this problem we faced two times in production database and also *Database Shutdown abort still * *not worked properly *and after restrarting database it;s start response to database setver
Problem in Alert Log file -
Mon Jul 10 13:12:24 2006 ORA-000060: Deadlock detected. More info in file d:\database\udump\vvvS001.TRC.
PMON failed to acquire latch, see PMON dump Wed Jul 12 20:43:19 2006 ORA-000060: Deadlock detected. More info in file d:\database\udump\lotteryS002.TRC.
PMON failed to acquire latch, see PMON dump Wed Jul 12 20:51:15 2006 ORA-000060: Deadlock detected. More info in file d:\database\udump\lotteryS000.TRC.
With Regards
Sachin Sethi
-- Alfonso Leon