Re: rollback segs in locally managed tablespace

From: Sven Tieste <sven.tieste_at_sw-hb.de>
Date: Wed, 23 Apr 2003 15:38:33 +0200
Message-ID: <3ea69759$0$18085$9b4e6d93@newsread4.arcor-online.net>

Hello,
thanks you all for quick answering.
I'm relieved to hear that it is a normal behaviour. And now I found docs about that (late but ...).

greetings
Sven

"Sven Tieste" <sven.tieste_at_sw-hb.de> schrieb im Newsbeitrag news:3ea51175$0$18082$9b4e6d93_at_newsread4.arcor-online.net...
> Hello,
> we have a Oracle 8.1.7.4 DB. Therefore I created a locally managed
> tablespace for
> rollback segs . 5 rbs have been created (db is quite small) . It makes me
a
> little bit nervous that afterwards the maxextents=32765.
> I created them all with a statement like:
> CREATE ROLLBACK SEGMENT R205
> TABLESPACE RBS_xxxT2
> STORAGE(
> MINEXTENTS 2
> MAXEXTENTS 30
> INITIAL 1024K
> OPTIMAL 2048K
> NEXT 1024K
> )
> So, question is why are maxextents are not 30.
> Maybe the locally managed tablespace is responsible for that.
> If so, is it documented?
> greetings,
> Sven
>
>
Received on Wed Apr 23 2003 - 08:38:33 CDT