Re: OPTIMAL and LMT's

From: Raymond <r_h_at_hetnet.nl>
Date: Tue, 13 Nov 2001 21:20:43 +0100
Message-ID: <9srusi$q0j$1@news1.xs4all.nl>

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:3bf16d2d$0$5065$afc38c87_at_news.optusnet.com.au...
> OPTIMAL is never a good idea, whatever sort of tablespace you've got, if
you
> value performance.

But what if you have huge transactions occasionally? Won't one of the RB segments in the RB tablespace take up almost all space, without ever making it available to the other segments? If you have such transactions, setting OPTIMAL for all your RB segments seems to be the only option. It isn't always possible to direct such transactions to a specific rollback segment...

Raymond. Received on Tue Nov 13 2001 - 14:20:43 CST