Oracle数据库中的Cache对象（1）

SQL> select segment_name,segment_type
,header_file,header_block
  2  from dba_segments where 
segment_type='CACHE';

SEGMENT_NAME    SEGMENT_TYPE  HEADER_FILE HEADER_BLOCK
------------- -------------- -------      --------
1.417            CACHE         1          417

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 <= 417
  3  order by a.header_block
  4  /

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

OBJECT_ID SEGMENT_NAME        SEGMENT_TYPE      HEADER_BLOCK
---------- -------------------- ------------------ ------------
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

OBJECT_ID SEGMENT_NAME        SEGMENT_TYPE      HEADER_BLOCK
---------- -------------------- ------------------ ------------
54         I_CCOL1              INDEX                      361
55         I_CCOL2              INDEX                      369
56         BOOTSTRAP$          TABLE                      377
          1.417                CACHE                      417

45 rows selected