Re: The deadlock graph and objn.

"Galen Boyer" <galenboyer_at_hotpop.com> a écrit dans le message de news:u1xicfp6f.fsf_at_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

Use data_object_id instead of object_id.

-- 
Regards
Michel Cadot