You have only two options that I am aware of.
- Only run your large transactions in off hours having first taken all
other rollback segments offline. This may well not be attractive to you.
- 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.
--
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 Fri Jul 26 2002 - 09:34:55 CDT
