oracle表空管理方式（LMT)、ASSM段管理方式、一级位图块、二级位图块、三级位图块。 - 数据库编程

l 0: [ 4] c3 03 0c 3d
tab 0, row 40, @0x1e50
tl: 8 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 4] c3 03 0c 3e
tab 0, row 41, @0x1e48
tl: 8 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 4] c3 03 0c 3f
tab 0, row 42, @0x1e40
tl: 8 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 4] c3 03 0c 40
tab 0, row 43, @0x1e38

。。。。。。。。。。。。。。

这就记录了数据信息。

继续查看第三个extent，第一个块48。

[oracle@oracle-one ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 22:06:00 2013

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 48;

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_3916.trc
1 Active Problem Count 0
1 Active Incident Count 0

11 rows selected.

SQL>
SQL>
SQL>
SQL> exit

Dump of First Level Bitmap Block
--------------------------------
nbits : 4 nranges: 1 parent dba: 0x0140000a poffset: 4
unformatted: 0 total: 16 first useful block: 2
owning instance : 1
instance ownership changed at 12/16/2013 21:06:21
Last successful Search 12/16/2013 21:06:21
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 :
--------------------------------------------------------
0x01400030 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 48 maxblk 48
这是第三个分区的第一个块，为第一位图块，管理16个块，父指针指向了第10个块二级位图块。

继续查看49个块

[oracle@oracle-one ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 22:11:30 2013

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 49;

System altered.

SQL> select * from v$diag_info;

oracle表空管理方式（LMT)、ASSM段管理方式、一级位图块、二级位图块、三级位图块。(八)