DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: advise about rollback tablespace in PRODUCTION database

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width