Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> The deadlock graph and objn.
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 BoyerReceived on Thu Aug 12 2004 - 08:45:11 CDT