Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: will the rollback seg space be used up and never shrink ?

    If I don't specify OPTIMAL in Rollback Seg , will the rollback seg space be used up and never shrink ?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Sep 2002
    Location
    Quebec
    Posts
    5
    What version are you using?
    If it's 8i and lower yes the space will be used and not freed
    you have to shrink your rollback segs manually
    altough the transaction in the rollback segs will be reused

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •