Re: set a rollback segment for a specific user

Karen wrote:

> A rollback segment can be assigned by calling a procedure from a package.
>
> I think it is DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT,
> although I can be mistaken.
>
> You probably do not need to research how to assign a rbs to a user.
>
> Regs
> AK
>
> Steven wrote:
>
> > Hi,
> >
> > I'm wondering if it is possible to set a specific rollback segment for a
> > user so that user only uses the specified rollback segment. My problem is
> > that sometimes I perform large transactions and want to use the large
> > rollback segment. However, I cannot specify the rollback segment using "set
> > transaction......" because I am accessing the data through an application.
> >
> > Any help will be appreciated,
> > Regards,
> > Steve.

This doesn't actually work for a number of reasons. Among them:

1. Everyone goes for the largest RBS
2. There is no guarantee that the specific RBS you are trying to get is available.

But that certainly has not stopped numerous developers, perhaps you too, into using it without understanding what it can potentially do to a system which is bring it to its knees.

Daniel Morgan Received on Mon Jul 29 2002 - 10:55:40 CDT