-
I have a quick question regarding about the production database.
Should we create one rollback tablespace and all of the rollback segements used this rollback tablespace or we should have each seperate rollback tablespace for each rollback segments ????
What is the advantage ???
Please advise
thanks
-
Depends on your rollback utilization/contention and available devices. If you only have one physical device, you will not gain any performance advantage.
In my OLTP databases, I like to put multiple groups of RBS into different tablespaces. That way, I can spread the I/O out on more than one I/O device.