Hi, all!
There is a tablespace named RBS containing 2 rollback segments : RB1,
RB2 in my database.
Today i check the sizes of these rollback segments by :
select segment_name, max(block_id+blocks-1)*8/1024
from dba_extents
where segment_name like '%RB%'
group by segment_name;
Segment_name Max(Block_
RB1 8.4453125
RB2 3.796875
But the size of the only datafile of RBS tablespace in the system is
10M (2M smaller).
What am I wrong here?
Thank you very much.
PS: The block size is 8K.
Received on Fri Feb 22 2002 - 23:02:48 CST
