Re: Question about Rollback Segment size.

In article <3870B57F.F937E280_at_bentley.com>,   Tom Best <Tom.Best_at_bentley.com> wrote:
> This makes sense. Also, if you ever have the need for a huge RBS,
then
> create it, use it, and then drop it. You can specify what RBS to use
with
> the SET TRANSACTION command.
>
> Francesco Dini wrote:
>
> > A simple question: is better to configure several equal RBS or of
> > different size ?
> > I think that is better to have several equal RBS because when a
> > transaction end to use one of them, another transaction can use the
same
> > segment.
> > What do you think?
> > Thanks.
>

RBS allocation size and number depends on your application needs, but it is generally recommended that all rbs segments be allocated with the same storage parameters if possible. Certain batch jobs like a year- end job might need a special segment but there are several options on how to handle these kind of needs.

Manually create them for the one time jobs followed by a drop, and for regular large jobs a large segment can be created, and brought on-line and taken back off-line by the job that needs it.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 09:45:14 CST