Skip to Content
author's profile photo Former Member
Former Member

ORA-00060 - Deadlock detected Error

Hello Gurus,

In Our BW Production Server we are facing follwoing error sice few days

BR0976W Database message alert - level: WARNING, line: 1572623, time: 2008-01-23 01.49.02, message:

ORA-00060: Deadlock detected. More info in file /oracle/PBW/saptrace/usertrace/pbw_ora_590014.trc.

BR0976W Database message alert - level: WARNING, line: 1572637, time: 2008-01-23 01.56.47, message:

ORA-00060: Deadlock detected. More info in file /oracle/PBW/saptrace/usertrace/pbw_ora_598066.trc.

Can anybody tell me the how to get rid of this error

Vital Information - Server

O/S - AIX

SAP Version - 700

Oracle - 10.2.0.2.0

ABAP Support Pack - SAPKA70010

Basis Support Pack - SAPKB70010

Patch - 95

Thanks & Regards

Shishir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 08:19 PM

    The trace file will be written to the directory indicated by the USER_DUMP_DEST init.ora parameter.

    The trace file will contain a deadlock graph and additional information similar to that shown below. This is the trace output from the above example which signaled an ORA-60 to Ses#2:

    The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock:

    Deadlock graph:

    -


    Blocker(s)--


    -
    Waiter(s)--


    Resource Name process session holds waits process session holds waits

    TX-00020012-0000025e 12 11 X 11 10 X

    TX-00050013-0000003b 11 10 X 12 11 X

    session 11: DID 0001-000C-00000001 session 10: DID 0001-000B-00000001

    session 10: DID 0001-000B-00000001 session 11: DID 0001-000C-00000001

    Rows waited on:

    Session 10: obj - rowid = 00000BF6 - AAAAv2AAEAAAAqKAAB

    Session 11: obj - rowid = 00000BF6 - AAAAv2AAEAAAAqKAAA

    -


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2008 at 10:33 AM

    Hello Shishir,

    the first thing we have to clarify is what is causing the ORA-00060. There are 2 types of an ORA-00060.

    One depends on the application (row level) and the other depends on the oracle rdbms (block level).

    We can identify this problem if you will post the lock graph out of the trace files.

    Now only my "guess":

    As you already said that you are using a BW.. you will recieve an ORA-00060, because of the bitmap indexes on the tables. If you have parallel inserts on tables which have some bitmap indexes ... you may recieve an ORA-00060.

    Take a look at sapnote #84348 or here:

    http://www.oratechinfo.co.uk/deadlocks.html#bitmap

    Please post the lock graphs.

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 10:56 AM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.