|
Commit complete. Elapsed: 00:00:00.00 SQL> select segment_name,extent_id,block_id,bytes,blocks from dba_extents where segment_name= 'T_ITDBA_1'; SEGMENT_NAME EXTENT_ID BLOCK_ID BYTES BLOCKS ------------------------------ ---------- ---------- ---------- ---------- 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 71 rows selected. Elapsed: 00:00:00.01 SQL> select bytes/1024 ,segment_name from dba_segments where segment_name='T_ITDBA_1'; BYTES/1024 SEGMENT_NAME ---------- ------------------------------ 57344 T_ITDBA_1 Elapsed: 00:00:00.01 SQL> delete from T_ITDBA_1 where owner='0'; 80528 rows deleted. Elapsed: 00:00:02.26 SQL> commit; Commit complete. Elapsed: 00:00:00.00 |