使用如下SQL,将这个DBA地址转换称对应的block,
Oracle rdba和 dba 说明
SQL> SELECTDBMS_UTILITY.data_block_address_file (
2 TO_NUMBER (LTRIM ('0x00400179', '0x'),'xxxxxxxx'))
3 AS file_no,
4 DBMS_UTILITY.data_block_address_block (
5 TO_NUMBER (LTRIM('0x00400179', '0x'), 'xxxxxxxx'))
6 AS block_no
7 FROM DUAL;
FILE_NO BLOCK_NO
---------- ----------
1 377
通过这个结果,可以看出DBA0x00400179 指向的是file 1 block 377.