Re: Assigning Individual Rollback Segments

Andreas Wilhelm <a_wilhelm_at_overnet.de> wrote:

>Dear All,
>
>we're looking for ways to assign the rollback segments' size to
>individual users/sessions.
>As you know it's possible to increase the general rollback segment size
>with the Database Expander of the Oracle Database tools (Using Oracle
>7.3). But Oracle also assigns individual portions of the rollback
>segment to each current session/user.
>Is there a way to define the size of those individual rollback segments?
>We need it to enable the users to undo complex transactions as e.g.
>deleting a customer entry with several hundreds of corresponding orders
>and invoices.
>
>Any help? Any idea?
>
>Looking forward. Kind regards,
>
>Andreas Wilhelm

Create a separate RBS just for those special transactions. Make it larger than the default ones. Then use SET TRANSACTION USE ROLLBACK SEGMENT XYZ to assign your special transactions to it.

--
Chuck Hamilton
Sr. DBA
Keystone Mercy Health Plan
chuckh_at_dvol.com

Press CTRL+ALT+DEL to continue.