Oracle 数据块，文件块转换，查看数据块对像

SQL> variable file# number
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('400179','xxxxxxx'));

PL/SQL procedure successfully completed.

SQL> variable block# number
SQL> execute :block#:=dbms_utility.data_block_address_block(to_number('400179','xxxxxxx'));

PL/SQL procedure successfully completed.

SQL> print file#

     FILE#
----------
         1

SQL> print block#

    BLOCK#
----------
       377

SQL> SQL> col segment_name for a30
SQL> col segment_type for a30
SQL> select segment_name,segment_type from dba_segments where header_file=1 and header_block=377;

SEGMENT_NAME                   SEGMENT_TYPE
------------------------------ ------------------------------
BOOTSTRAP$                     TABLE

SQL> select b.object_id,a.segment_name,a.segment_type,a.header_block from dba_segments a,dba_objects b
  2  where a.segment_name = b.object_name(+) and a.header_file=1 and a.header_block<=377
  3  order by a.header_block;

OBJECT_ID SEGMENT_NAME                   SEGMENT_TYPE                   HEADER_BLOCK
--------- ------------------------------ ------------------------------ ------------
          SYSTEM                         ROLLBACK                                  9
        2 C_OBJ#                         CLUSTER                                  25
        3 I_OBJ#                         INDEX                                    49
        6 C_TS#                          CLUSTER                                  57
        7 I_TS#                          INDEX                                    65
        8 C_FILE#_BLOCK#                 CLUSTER                                  73
        9 I_FILE#_BLOCK#                 INDEX                                    81
       10 C_USER#                        CLUSTER                                  89
       11 I_USER#                        INDEX                                    97
       15 UNDO$TABLE                                   105        17 FILE$                          TABLE                                   113
       18 OBJ$TABLE                                   121        23 PROXY_DATA$                    TABLE                                   129
       24 I_PROXY_DATA$INDEX                                   137        25 PROXY_ROLE_DATA$               TABLE                                   145
       26 I_PROXY_ROLE_DATA$_1           INDEX                                   153        27 I_PROXY_ROLE_DATA$_2           INDEX                                   161
       28 CON$TABLE                                   169        29 C_COBJ#                        CLUSTER                                 177        30 I_COBJ#                        INDEX                                   185        33 I_TAB1                         INDEX                                   193        34 I_UNDO1                        INDEX                                   201        35 I_UNDO2                        INDEX                                   209        36 I_OBJ1                         INDEX                                   217        37 I_OBJ2                         INDEX                                   225        38 I_OBJ3                         INDEX                                   233        39 I_IND1                         INDEX                                   241        40 I_ICOL1                        INDEX                                   249        41 I_FILE1                        INDEX                                   257        42 I_FILE2                        INDEX                                   265        43 I_TS1                          INDEX                                   273        44 I_USER1                        INDEX                                   281        45 I_COL1                         INDEX                                   289        46 I_COL2                         INDEX                                   297        47 I_COL3                         INDEX                                   305        48 I_CON1                         INDEX                                   313        49 I_CON2                         INDEX                                   321        50 I_CDEF1                        INDEX                                   329        51 I_CDEF2                        INDEX                                   337        52 I_CDEF3                        INDEX                                   345        53 I_CDEF4                        INDEX                                   353        54 I_CCOL1                        INDEX                                   361        55 I_CCOL2                        INDEX                                   369        56 BOOTSTRAP$                     TABLE                                   377

44 rows selected.

SQL> SQL>