last used ext fileid....................15 <==file id of last used extent
last used ext blockid...................562 <==block id of last used extent
last used block.........................1 <==last used block in extent
pl/sql 过程已成功完成。
有关show_space的进一步使用技巧可参考文献5。以下利用上面得到的数据对segment header block进行dump。
sql>alter system dump datafile 15 block 562;
在udump/ora10792.trc中
*** 2004-09-08 15:29:57.343
start dump data blocks tsn: 27 file#: 15 minblk 562 maxblk 562
buffer tsn: 27 rdba: 0x03c00232 (15/562)
scn: 0x0000.064560e4 seq: 0x02 flg: 0x00 tail: 0x60e41002
frmt: 0x02 chkval: 0x0000 type: 0x10=data segment header - unlimited
extent control header
-----------------------------------------------------------------
extent header:: spare1: 0 space2: 0 #extents: 1 #blocks: 4
last map 0x00000000 #maps: 0 offset: 2080
highwater:: 0x03c00233 ext#: 0 blk#: 0 ext size: 4
