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>