查看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 4
Extent Map Block Offset: 4294967295
First free datablock : 0
Bitmap block lock opcode 0
Locker xid: : 0x0000.000.00000000
Dealloc scn: 925704.0
Flag: 0x00000001 (-/-/-/-/-/HWM)
Inc #: 0 Objd: 87521
HWM Flag: HWM Set
Highwater:: 0x0140001c ext#: 0 blk#: 20 ext size: 20
#blocks in seg. hdr's freelists: 0
#blocks below: 16
mapblk 0x00000000 offset: 0
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x01400018 Length: 4 Offset: 0
0:75-100,% free 1:75-100,% free 2:75-100,% free 3:75-100,% free
--------------------------------------------------------
End dump data blocks tsn: 6 file#: 5 minblk 9 maxblk 9
父指针指向第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


热门课程培训
热门培训机构
