Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> The deadlock graph and objn.

The deadlock graph and objn.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 12 Aug 2004 08:45:11 -0500
Message-ID: <u1xicfp6f.fsf@standardandpoors.com>


Oracle 9i, W2K.

The snippet I'm interested in is the following:

    Session 18: obj - rowid = 000887D8 - AAAAAAAALAAAANCAAA
(dictionary objn - 559064, file - 11, block - 834, slot - 0)
    Session 9: obj - rowid = 0008824E - AAAAAAAALAAAAGIAAA
(dictionary objn - 557646, file - 11, block - 392, slot - 0)

Here is my SQL:

SQL> select object_id, owner, object_name from dba_objects where object_id in (559064,557646);

 OBJECT_ID OWNER OBJECT_NAME

---------- -------------------- ----------------------------------------
    559064 GRERS		PROPERTY_B

The objn of 557646 doesn't bring back anything. What type of object would this be, or is objn not the object_id found in dba_objects?

-- 
Galen Boyer
Received on Thu Aug 12 2004 - 08:45:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US