Re: Help me : urgent

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_at_telserra.com> 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

--
http://www.freelists.org/webpage/oracle-l