-------- T_ITDBA_1 0 18560 65536 8 T_ITDBA_1 1 18568 65536 8 T_ITDBA_1 2 18576 65536 8 T_ITDBA_1 3 18584 65536 8 T_ITDBA_1 4 18592 65536 8 T_ITDBA_1 5 18600 65536 8 T_ITDBA_1 6 18608 65536 8 T_ITDBA_1 7 18616 65536 8 T_ITDBA_1 8 18624 65536 8 T_ITDBA_1 9 18632 65536 8 T_ITDBA_1 10 18640 65536 8 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 11 18648 65536 8 T_ITDBA_1 12 18656 65536 8 T_ITDBA_1 13 18664 65536 8 T_ITDBA_1 14 18672 65536 8 T_ITDBA_1 15 18680 65536 8 T_ITDBA_1 16 18688 1048576 128 T_ITDBA_1 17 18816 1048576 128 T_ITDBA_1 18 18944 1048576 128 T_ITDBA_1 19 19072 1048576 128 T_ITDBA_1 20 19200 1048576 128 T_ITDBA_1 21 19328 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 22 19456 1048576 128 T_ITDBA_1 23 19584 1048576 128 T_ITDBA_1 24 19712 1048576 128 T_ITDBA_1 25 19840 1048576 128 T_ITDBA_1 26 19968 1048576 128 T_ITDBA_1 27 20096 1048576 128 T_ITDBA_1 28 20224 1048576 128 T_ITDBA_1 29 20352 1048576 128 T_ITDBA_1 30 20480 1048576 128 T_ITDBA_1 31 20608 1048576 128 T_ITDBA_1 32 20736 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 33 20864 1048576 128 T_ITDBA_1 34 20992 1048576 128 T_ITDBA_1 35 21120 1048576 128 T_ITDBA_1 36 21248 1048576 128 T_ITDBA_1 37 21376 1048576 128 T_ITDBA_1 38 21504 1048576 128 T_ITDBA_1 39 21632 1048576 128 T_ITDBA_1 40 21760 1048576 128 T_ITDBA_1 41 21888 1048576 128 T_ITDBA_1 42 22016 1048576 128 T_ITDBA_1 43 22144 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 44 22272 1048576 128 T_ITDBA_1 45 22400 1048576 128 T_ITDBA_1 46 22528 1048576 128 T_ITDBA_1 47 22656 1048576 128 T_ITDBA_1 48 22784 1048576 128 T_ITDBA_1 49 22912 1048576 128 T_ITDBA_1 50 23040 1048576 128 T_ITDBA_1 51 23168 1048576 128 T_ITDBA_1 52 23296 1048576 128 T_ITDBA_1 53 23424 1048576 128 T_ITDBA_1 54 23552 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 55 23680 1048576 128 T_ITDBA_1 56 23808 1048576 128 T_ITDBA_1 57 23936 1048576 128 T_ITDBA_1 58 24064 1048576 128 T_ITDBA_1 59 24192 1048576 128 T_ITDBA_1 60 24320 1048576 128 T_ITDBA_1 61 24448 1048576 128 T_ITDBA_1 62 24576 1048576 128 T_ITDBA_1 63 24704 1048576 128 T_ITDBA_1 64 24832 1048576 128 T_ITDBA_1 65 24960 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 66 25088 1048576 128 T_ITDBA_1 67 25216 1048576 128 T_ITDBA_1 68 25344 1048576 128 T_ITDBA_1 69 25472 1048576 128 T_ITDBA_1 70 128 1048576 128 T_ITDBA_1 71 256 1048576 128 T_ITDBA_1 72 384 1048576 128 T_ITDBA_1 73 512 1048576 128 T_ITDBA_1 74 640 1048576 128 T_ITDBA_1 75 768 1048576 128 T_ITDBA_1 76 896 1048576 128 SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- T_ITDBA_1 77 1024 1048576 128 T_ITDBA_1 78 1152 1048576 128 T_ITDBA_1 79 1280 8388608 1024 T_ITDBA_1 80 2304 8388608 1024 T_ITDBA_1 81 3328 8388608 1024 T_ITDBA_1 82 4352 8388608 1024 T_ITDBA_1 83 5376 8388608 1024 84 rows selected. Elapsed: 00:00:00.02 SQL>
?
?
这个时候发现会有很多空块
?
SQL> select segment_name, extent_id, block_id, bytes, blocks
2 from dba_