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
    Location
    Shanghai
    Posts
    433
    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
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Jun 2002
    Posts
    73
    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.
    MAS
    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