Any problem in keeping extra Rollback Segs. Online
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Any problem in keeping extra Rollback Segs. Online

  1. #1
    Join Date
    Nov 2000
    Posts
    224

    Question

    Just want to know Guru's opinion,

    What is the problem if I will keep more or extra no. of RBS online.
    Hard Disk space is not a issue for me et all. What other impacts I may see because of it. Any negative impacts.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    AFAIK, No -ve impact at all on the database.

    But make sure you limit the number of extents on the RBS. If you have too many RBS with too many extents it might more resources to extend and shrink....


    [Edited by sreddy on 06-11-2002 at 04:07 PM]
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    It depends on what kind of transactios you have on the database, let say you have very big transaction(s) , which can cause huge undo and you also have a many small rollback segments , Oracle will still bless you with ORA-1555.

    Size does Matter, may not be number always


    Madhu Reddy
    xdollor@yahoo.com

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no negative impact , in fact in 9i if you want to keep an old enough undo in order to use flahsback query you might as well have a huge undo tablespace

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