Size of Rollback Segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Size of Rollback Segment

  1. #1
    Join Date
    May 2000
    Posts
    50
    Is there a limit on how big can a rollback segment could be? I am using oracle 8.1.7.2 on Solaris 5.7

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Your rollback segment can be as large as you want providing you have the appropriate amount of disk space.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2002
    Posts
    59
    Rollback segment can grow as any data segment provided Maxextents is not reached and Diskspace is available.
    i.e. it can grow to a size of 166500 datafiles for a TBLSP * 34G ( on 64bit solaris ) = 5661000GB, or less than maxextents for ur Rollbacksegment ( I dont remember maxextents for Solaris ).

    Thanx
    Sanjay

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    MAXEXTENTS can be UNLIMITED. Again, there is no limit as long as you have enough disk space.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by marist89
    MAXEXTENTS can be UNLIMITED. Again, there is no limit as long as you have enough disk space.
    I wonder why when MAXEXTENTS is UNLIMITED and you extract the DDL with SQL Navigator, say for a given table, SQL Navigator sets some very large number.


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