Any problem in keeping extra Rollback Segs. Online 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


    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
    Washington DC
    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]

  3. #3
    Join Date
    Feb 2001
    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

  4. #4
    Join Date
    Jun 2000
    Madrid, Spain
    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