Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where can I set the optimal parameter for rollback segments?

Re: Where can I set the optimal parameter for rollback segments?

From: Alfons Riesebeek <A.Riesebeek_at_wxs.nl>
Date: 14 Aug 1998 12:42:32 GMT
Message-ID: <01bdc781$01d61d80$202d15ac@tonta000157>


Try this:

ALTER or CREATE ROLLBACK SEGMENT RBS1

STORAGE(	INITIAL		10K
		NEXT		10K
		OPTIMAL 	20K)

/
Regards,
Alfons Riesebeek

Birgit Merschmann <B.Merschmann_at_invent.de> schreef in artikel <35d41c91.0_at_news.teuto.de>...
> Hi,
>
> we've some problems with the extends of the rollback segments. Now I've
read
> about setting an optimal parameter giving free elderly extents but I
can't
> find where I can set this parameter. Can anybody help?
> Thanks in advance,
>
> Birgit
>
> B.Merschmann_at_invent.de
>
>
>
Received on Fri Aug 14 1998 - 07:42:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US