-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|