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

父指针指向第10个块parent dba: 0x0140000a
当插入数据之后：

SQL> show user
USER is "SYS"
SQL> conn sudo[amy]/proxy
Connected.
SQL> begin
2 for i in 202..200000 loop
3 insert into t(a) values(i);
4 commit;
5 end loop;
6 end;
7 /

PL/SQL procedure successfully completed.

SQL> select owner,segment_name,segment_type,file_id,extent_id,block_id,BLOCKS from dba_extents where segment_name='T';

OWNER SEGMENT_NAME SEGMENT_TYPE FILE_ID EXTENT_ID BLOCK_ID BLOCKS
------------------------------ ---------------------------------------- ------------------ ---------- ---------- ---------- ----------
AMY T TABLE 5 0 8 20
AMY T TABLE 5 1 28 20
AMY T TABLE 5 2 48 20
AMY T TABLE 5 3 68 20
AMY T TABLE 5 4 88 20
AMY T TABLE 5 5 108 20
AMY T TABLE 5 6 128 20
AMY T TABLE 5 7 148 20
AMY T TABLE 5 8 168 20
AMY T TABLE 5 9 188 20
AMY T TABLE 5 10 208 20

OWNER SEGMENT_NAME SEGMENT_TYPE FILE_ID EXTENT_ID BLOCK_ID BLOCKS
------------------------------ ---------------------------------------- ------------------ ---------- ---------- ---------- ----------
AMY T TABLE 5 11 228 20
AMY T TABLE 5 12 248 20
AMY T TABLE 5 13 268 20
AMY T TABLE 5 14 288 20
AMY T TABLE 5 15 308 20
AMY T TABLE 5 16 328 20

17 rows selected.

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

11 rows selected.

查看trace日志：

Dump of First Level Bitmap Block
--------------------------------
nbits : 4 nranges: 1 parent dba: 0x0140000a poffset: 1
unformatted: 0 total: 4 first useful block: 0
owning instance : 1
instance ownership changed at 12/16/2013 20:38:38
Last successful Search 12/16/2013 20:38:38
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0

Extent Map Block Offset: 4294967295
First free datablock : 4
Bitmap block lock opcode 0
Locker xid: : 0x0000.000.00000000
Dealloc scn: 925704.0
Flag: 0x00000000 (-/-/-/-/-/-)
Inc #: 0 Objd: 87521
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x01400018 Length: 4 Offset: 0

0:FULL 1:FULL 2:FULL 3:FULL
--------------------------------------------------------
End dump data blocks tsn: 6 file#: 5 minblk 9 maxblk 9
该位图块管理的数据块以及填满数据。父指针指向第10个块parent dba: 0x0140000a

查看第10个块：

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

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 21:11:20 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