Oracle-L: Re: deadlock graph -- obj identification

From: <Jared.Still_at_radisys.com>
Date: Fri, 18 Apr 2003 16:51:41 -0800
Message-ID: <F001.00585395.20030418165141@fatcity.com>

Please see MetaLink notes 131885.1 and 62365.1 .

FYI, the SQL that caused the deadlock is included in the trace file.

Jared

sat0789_at_fastmail.fm
Sent by: root_at_fatcity.com
04/18/2003 05:21 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        deadlock graph -- obj identification

Hello all,
We are having a deadlock situation and i am trying to locate the object id
the query that i run is
select to_number('00020032','xxxxxx') from dual and the value that i get, i look into dba_objects where object_id is the one returned from the first query.

When i do that i get no rows returned from dba_objects. Am i doing something wrong...???

Deadlock graph:

                       ---------Blocker(s)-------- 
                       ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds
waits
TX-00020032-0000024d         8      12     X             29      22 
    S
TX-00130039-00001996        29      22     X              8      12 
    S
session 12: DID 0001-0008-00000002      session 22: DID
0001-001D-00000002
session 22: DID 0001-001D-00000002      session 12: DID

0001-0008-00000002

Thanks,

--

http://www.fastmail.fm - The professional email service
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: sat0789_at_fastmail.fm

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------