Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: deadlock problem
we use Oracle Applications 11i (11.5.9) as application side, we always
got ORA-00060 on alert.log. i check 'top' command on server at this
time (when deadlock occurred) and see all oracle server process is in
sleep state except one that is in run state.
at this time if i want to connect to database or even select any table
(v$session_wait for example) or use oradebug(hang analyse) from
previously logon session, i can`t do and must wait until deadlock
resolve by oracle.
thank you
Jonathan Lewis wrote:
> If you are using the term "deadlock" correctly, you
> should find a trace file in the directory identified by
> parameter user_dump_dest.
>
> This should give you the first clues about where the
> deadlock is coming from. This will indicate one of
> two issues, ORA-00060 which typically will be a code
> or design error on the part of the application, not an
> error on the part of Oracle, or ORA-04020 which
> is more likely to be a coding error in the Oracle kernel
> that has been triggered by an "unanticipated" use of
> DDL in your application.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> <h.jalalipoor_at_gmail.com> wrote in message
> news:1164177256.919656.49280_at_m7g2000cwm.googlegroups.com...
> >I have oracle 9.2.0.3 on HP9000 PA-RISC 64Bit (12GB RAM and 6 CPU).
> > database size is about 100GB and active users is about 200 user.
> > when a deadlock detected, my database hang for a few minutes, no body
> > can`t do any thing even dba. I want to connect as sysdba from SQL*Plus
> > but i can`t and SQL*Plus wait until deadlock detection resolved by
> > oracle.
> > my question is what happen on database when a deadlock detected? is it
> > a bug or it is normal?
> >
> > best regards.
> >
Received on Wed Nov 22 2006 - 04:39:48 CST