This content has been marked as final. Show 2 replies
You need to convert from Hex to Decimal.
0x0100216e = 16785774
A similar example here :-
Thanks the second link it's really helpful, what I had problems is how file# and block data# are coded together on the hex number. Your second link at least show how to get these values:
select DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(16785774) from x$dual;
select DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(16785774) from x$dual;