Re: rollback segs in locally managed tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 22 Apr 2003 23:37:37 +1000
Message-ID: <1nbpa.20183$1s1.299095@newsfeeds.bigpond.com>

"Sven Tieste" <sven.tieste_at_sw-hb.de> wrote in message 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,

Hi Sven,

I like LMTs, don't get me wrong, but you've come across the one thing I don't like about them. The inability to set a maxextents limit and that any value you set gets ignored with unlimited being the only possible value.

This inability to use maxextents for it's capacity management benefits is unfortunate.

Yes, this is well documented.

Cheers

Richard Received on Tue Apr 22 2003 - 08:37:37 CDT