Re: Help me : urgent

  • From: "Alfonso León" <aleon68@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 17 Jul 2006 09:24:53 -0500

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

On 7/17/06, Sachin Sethi <s.sethi@xxxxxxxxxxxx> wrote:

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

Other related posts: