Re: rollback segments and performance

From: Ben Ryan <benryan_at_my-deja.com>
Date: Tue, 07 Sep 1999 20:20:41 GMT
Message-ID: <7r3s29$33p$1@nnrp1.deja.com>

In article <37D24E53.29D6AF95_at_netscape.com>, John Chiu <johnymc_at_netscape.com> wrote:
> your problem may be caused by the huge number of extents for the
rollback
> segments and the size of each rbs
> rbs #extents size
> rbs0,rbs1 200 approx 50m
> rbs1,rbs3 103 approx 25m
> the rollback segment always shrink to optimal.
>
> why not try to create the rbs using the following storage clause:
>
> STORAGE(INITIAL 25m
> NEXT 25m
> MINEXTENTS 1
> MAXEXTENTS whatever
> OPTIMAL 25M);
Aren't rollback segments supposed to have a minimum of two extents? I believe this true in both Oracle7.3 and Oracle8.0. On Oracle7.3 you get the following error.
ORA-01556: MINEXTENTS for rollback segment must be greater than 1 See Oracle7 Concepts p3-19 and Oracle7 SQL reference 4-451.

>
> John Chiu
> johnymc_at_netscape.net
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 15:20:41 CDT