Re: Alter rollback segments

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076533861.884709_at_yasure>...
> Patrik wrote:
>
> > Hi,
> >
> > I want to add "alter rollback segments" and "set transaction use
> > rollback..."
> > in my otherwise functioning procedure. I have to control which
> > rollbackseg that the proc uses when it updates due to very large
> > transactions.
>
> Why?
>
> Every bit of 'good' advice from Tom Kyte and other experts indicates
> that this is a bad idea. Just resize your rollback segments appropriately.
>
> And if you have 9i ... you shouldn't be using rollback segments at all

The enviroment is Oracle 8.1.7 and OPS each node (2) has 20 rollbacksegs that the main ERP-system and other smaller apps uses. What I'm doing is running special scripts and now procedures that is more heavy on rollbacksegs than usual. My idea is instead of increasing the size 40 rollbacksegs (we don't have that much diskspace anyway) I make 2 big rollbacksegs that is default offline and I use them only for this purpuse. I'm not an Oracle expert so I'm thankful for every bit of advice I get, but it seems to me that your suggestion wouldn't work in my case.

/Patrik Received on Thu Feb 12 2004 - 01:47:01 CST