Can someone explain to me the output from dba_free_space?
The columns seem simple enough...bytes is just blocks*
oracle block size etc., I'm wondering though what the
significance of this view is...the blocks aren't in sequence,
why is that? Does these "free spaces" represent fragmentation?
If so, what kind? Table, tablespace, empty extents?
I appreciate any feedback.
Thanks,
Dc.
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
------------------------------ --------- --------- --------- ---------
SYSTEM 1 971 13025280 1590
RBS 2 42 2809856 343
DATA01 3 266 286720 35
DATA01 3 122 16384 2
DATA01 3 134 16384 2
DATA02 5 2 1220608 149
TEMP 6 2 2088960 255
INDX01 4 12 958464 117
8 rows selected.
Received on Sat Oct 31 1998 - 22:10:44 CST
