Urgent: Oracle 7.3.4 Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Urgent: Oracle 7.3.4 Question

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Exclamation

    In version 7.3.4 Why would you have a Rollback segment on the System Tablespace Vs. an RBS tablespace?? This question was asked by 1 dba to me and I couldnt answer it...
    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    its best to group segment types into their own tablespace for performance and manageability

    system tablespace should only be used for the data dictionary

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by jlakhani
    In version 7.3.4 Why would you have a Rollback segment on the System Tablespace Vs. an RBS tablespace??
    Why would you? Because you have no choice - one rollback segment (named SYSTEM) is allways online and must reside in system tablespace, it can't live anywhere else. And this is not 7.3.4 specific, it's for all releases.

    For other rollback segments though there is a simple answer to the above question: You simply don't want any other rollback segments that are in use to be in system tablespace, they should be in separated tablespace(s) dedicated only to rollback segments.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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