Re: rollback segments and performance

From: John Chiu <johnymc_at_netscape.com>
Date: Sun, 05 Sep 1999 07:04:51 -0400
Message-ID: <37D24E53.29D6AF95@netscape.com>

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);

John Chiu
johnymc_at_netscape.net Received on Sun Sep 05 1999 - 06:04:51 CDT