Hi everyone,
I am issuing a query to find tablespace fragmentation. I ran this query on the Rollback tablespace.
select * from dba_free_space
where tablespace_name = 'RBS'
order by file_id, block_id;
FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
------- ---------- ---------- ---------- ------------
3 327 532480 130 3
3 1482 24289280 5930 3
3 9592 222863360 54410 3
10 132 29020160 7085 10
10 10292 219996160 53710 10
11 2 22364160 5460 11
11 9887 221655040 54115 11
By starting with the block_id (327) and adding the blocks (130) if they = (1482) next block_id then the space is to be contiguous. Is this correct? If so why would there be any fragmentation in a rollback tablespace, isn't everything released when the transaction has ended?
Some clarification would help, thank you.
Kathy
