Extent 1 : L1 dba: 0x0140001c Data dba: 0x0140001e
Extent 2 : L1 dba: 0x01400030 Data dba: 0x01400032
Extent 3 : L1 dba: 0x01400044 Data dba: 0x01400046
Extent 4 : L1 dba: 0x01400058 Data dba: 0x0140005a
Extent 5 : L1 dba: 0x0140006c Data dba: 0x0140006e
Extent 6 : L1 dba: 0x01400080 Data dba: 0x01400081
Extent 7 : L1 dba: 0x01400080 Data dba: 0x01400094
Extent 8 : L1 dba: 0x01400080 Data dba: 0x014000a8
Extent 9 : L1 dba: 0x014000bc Data dba: 0x014000bd
Extent 10 : L1 dba: 0x014000bc Data dba: 0x014000d0
Extent 11 : L1 dba: 0x014000bc Data dba: 0x014000e4
Extent 12 : L1 dba: 0x014000f8 Data dba: 0x014000f9
Extent 13 : L1 dba: 0x014000f8 Data dba: 0x0140010c
Extent 14 : L1 dba: 0x014000f8 Data dba: 0x01400120
Extent 15 : L1 dba: 0x01400134 Data dba: 0x01400135
Extent 16 : L1 dba: 0x01400134 Data dba: 0x01400148
--------------------------------------------------------
Second Level Bitmap block DBAs
--------------------------------------------------------
DBA 1: 0x0140000a
End dump data blocks tsn: 6 file#: 5 minblk 11 maxblk 11
可以看出11块为数据段头信息。
继续查看第二个extent的第一个块（28块）
oracle@oracle-one ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 21:25:41 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> set linesize 200
SQL> col name for a30
SQL> col value for a70
SQL> alter system dump datafile 5 block 28;
System altered.
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- ------------------------------ ----------------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /opt/app/oracle
1 ADR Home /opt/app/oracle/diag/rdbms/rhys/RHYS
1 Diag Trace /opt/app/oracle/diag/rdbms/rhys/RHYS/trace
1 Diag Alert /opt/app/oracle/diag/rdbms/rhys/RHYS/alert
1 Diag Incident /opt/app/oracle/diag/rdbms/rhys/RHYS/incident
1 Diag Cdump /opt/app/oracle/diag/rdbms/rhys/RHYS/cdump
1 Health Monitor /opt/app/oracle/diag/rdbms/rhys/RHYS/hm
1 Default Trace File /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3650.trc
1 Active Problem Count 0
1 Active Incident Count 0
11 rows selected.
Dump of First Level Bitmap Block
--------------------------------
nbits : 4 nranges: 1 parent dba: 0x0140000a poffset: 2
unformatted: 0 total: 16 first useful block: 2
owning instance : 1
instance ownership changed at 12/16/2013 21:06:16
Last successful Search 12/16/2013 21:06:16
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
Extent Map Block Offset: 4294967295
First free datablock : 16
Bitmap block lock opcode 0
Locker xid: : 0x0000.000.00000000
Dealloc scn: 925704.0
Flag: 0x00000000 (-/-/-/-/-/-)
Inc #: 0 Objd: 87521
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x0140001c Length: 16 Offset: 0
0:Metadata 1:Metadata 2:FULL 3:FULL
4:FULL 5:FULL 6:FULL 7:FULL
8:FULL 9:FULL 10:FULL 11:FULL
12:FULL 13:FULL 14:FULL 15:FULL
--------------------------------------------------------
End dump data blocks tsn: 6 file#: 5 minblk 28 maxblk 28
这一是第二个extent的第一位图块，父指针为第10个块。
查看第29个块。
oracle@oracle-one ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 21:27:36 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Datab