Re: Rollback

Hello

You will get an error message, oracle won't give you access to another rollback segment. Oracle uses a cyclic queue to assign a transaction to a rollback segment, so the transaction are distributed automaticly to different rollback segments to improve database performance. Every rollback segment can contain several transactions. For big transaction it is usefull to create a big rollbacksegment and assign the transaction by "set transaction use rollback segment <segment-name>" to a specific rollback segment.

I hope this answers your question

regards
thomas

peter.mckenzie_at_health.wa.gov.au wrote in message news:<9upcq6$u78$1_at_news.netmar.com>...
> If I start updating data within an sql session I am allocated a rollback
> segment. If I don't commit and reach the max extents for the segment will I
> get an error message or will I then be given access to another rollback
> segment?
>
> How does Oracle decide which rollback segment to assign ?
>
> Thanks
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Fri Dec 07 2001 - 04:20:49 CST