Re: The deadlock graph and objn.

Galen Boyer <galenboyer_at_hotpop.com> wrote in message 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?

data_object_id.

Jonathan Lewis has some interesting views for this up on his site, I believe.

-bdbafh Received on Thu Aug 12 2004 - 14:32:13 CDT