Re: set a rollback segment for a specific user

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d415e0f$0$238$ed9e5944_at_reading.news.pipex.net...
> You have only two options that I am aware of.
>
> 1. Only run your large transactions in off hours having first taken all
> other rollback segments offline. This may well not be attractive to you.
> 2. Size all rollback segments equally and large enough to hold the data
> required for your largest transaction. This would be the preferred advice
in
> these days of exceptionally cheap storage.

creating large rollback segments is appealing to me but won't this affect performance of smaller transactions? We have lots of very small transacitons just inserting one row, updating one row. Is this a major problem?

>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Steven" <steven.pannell_at_gmx.net> wrote in message
> news:ahrlbh$vi73t$1_at_ID-82797.news.dfncis.de...
> > 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.
> >
> >
> >
>
>
Received on Sat Jul 27 2002 - 06:01:36 CDT