Hello everyone.
I've been analyzing a trace related to the recent ORA-00060
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00060013-000cae80 166 180 X 100 122 S
TX-0028000e-0000cd68 100 122 X 166 180 S
session 180: DID 0001-00A6-00000064 session 122: DID 0001-0064-00000002
session 122: DID 0001-0064-00000002 session 180: DID 0001-00A6-00000064
Rows waited on:
Session 180: obj - rowid = 00017A3A - AAAXo6AAAAAAAAAAAA
(dictionary objn - 96826, file - 0, block - 0, slot - 0)
Session 122: obj - rowid = 00017A3A - AAAXo6AAAAAAAAAAAA
(dictionary objn - 96826, file - 0, block - 0, slot - 0)
As you can see here we have objn which corresponds to the OBJECT_ID in the dba_objects table:
select owner, object_name, OBJECT_TYPE from dba_objects where OBJECT_ID=96826;
PAYNET IDX$PAY_OPER#STATUS INDEX
select table_name from dba_indexes where INDEX_NAME in (select object_name from dba_objects where OBJECT_ID=96826 and owner='PAYNET');
TBL$PAY_OPER ( so here is related table)
After that that we can see rowid which is equal to 'AAAXo6AAAAAAAAAAAA'
So i take the value of the rowid and put it to the query
select * from TBL$PAY_OPER where rowid like 'AAAXo6AAAAAAAAAAAA';
and have nothing in returne
above that all that related stuff above file - 0, block - 0, slot - 0
all zeros
Could someone put here some comments please?