Oracle-L: deadlock graph -- obj identification

From: <sat0789_at_fastmail.fm>
Date: Fri, 18 Apr 2003 16:21:51 -0800
Message-ID: <F001.00585378.20030418162151@fatcity.com>

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). Received on Fri Apr 18 2003 - 19:21:51 CDT