Will the space is used up in RollbackSeg ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Will the space is used up in RollbackSeg ?

  1. #1
    Join Date
    Aug 2000
    If I don't specify OPTIMAL in Rollback Seg , will the rollback seg space be used up and never shrink ?

    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com

  2. #2
    Join Date
    Jun 2002
    In RBS the key word OPTIMAL is used to shrink back the extents if exceeded OPTIMAL limit and going towards MAXEXTENTS. It's very useful to cut down unnecessary space usage. Yeah, if you don't mention OPTIMAL then it will go on increasing towards the MAXEXTENTS and will not decrease unless you issue the SHRINK command.
    You cannot succeed if you fear to face challenges.
    BE(CS) , OCP 8/8i.

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