I was asked by some one like this:
When we have a big trasaction, we will assign it to a BIG rollback segment to handle it.
How big it can be. Do we keep increasing it as we need or what is the best way of handling the BIG transaction. What is the limit.
Can any one clarify this as I could not think any think else other than increasing the size as we need. But it may not be practical.