Re: understanding rollback segments

Dave,

A new transaction will always start to write its rollback information in an new oracle block, not necessarily in a new (rbs-)extent. For this type of activity you should take at least two rollback segments. Oracle will always assign you the rbs with the least nr of active transactions. This means that if the other user is 'blocking' the first rbs, you will be assigned the second (non-active) rbs which will wrap around and not grow.

Geert.

-- 

Sometimes, it is better to keep your mouth shut
and appear the fool, than to speak and prove yourself one.
                          ______  ______  __    __  _____  ____
Geert De Paep            / ____/ __  __/         /   __  /  __ |
Cimad Consultants       / /         /     /|_/  /   /_  /  /   /
Groenenborgerlaan 16   / /         /     /     /   __  /  /   /
2610 Antwerpen        /_____/ ______/ __/   __/ __/ __/ _____/
http://www.cimad.be   Email: gdp@cimad.be   Tel: 03/820 82 50