Re: Among of rollback segments are different than the specified

I don't know if I understood you well. First you wrote about min extents of rollback segment and then about min extents of tablespace. This is not the same. When you create rollback segment you may specify it's storage parameters (by default storage parameters of rollback segment are the same as storage parameters for the rollback segment tablespace). You can check actual parameters of your rollback segments by using select, for instance:

select segment_name, tablespace_name, bytes, blocks, extents from sys.dba_segments where segment_type = 'ROLLBACK';

hope this helps

Peter

Birgit Merschmann wrote:

> Hi,
>
> When I create my database (oracle 8) with the database assistant I set the
> min extents of rollback segments to 16 but when creating the database my
> tablespace has only 2. I can't explain to myself why oracle ignored it
> because all the other settings are properly fulfilled.
> Thanks in advance for any help.
>
> Birgit
>
> B.Merschmann_at_invent.de
Received on Mon Aug 17 1998 - 08:37:10 CDT