Resize rollback segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Resize rollback segment

  1. #1
    Join Date
    Jan 2001
    Posts
    318
    How do I increase the size of a rollback segment ?
    I get following error.
    ORA-01562: failed to extend rollback segment number 2 ORA-01650: unable to
    extend rollback segment RBS02 by 256 in tablespace ROLLBACK
    ORA-06512: at "A4.PR_WORFINDFX", line 138 ORA-06512: at line 1 Error Code
    SQL or AFX: -1

    Do I have to add a new rollback segment ?
    Sonali

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Increase the number of MaxExtents for the rollback segment.
    If there is not enough space in the tablespace, then you will need to add a datafile as well.

    - Rajeev

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Another thing you can do is set Autoextend ON.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sonali,

    Your ORA message is teling you there is not enough free space in your RB tablespace to extentend a rolback segment, so it has nothing to do with MAXEXTENTS. You should simply make more free space in your RB tablespace by one of the following:

    a) add new datafile to tablespace
    b) as Halo already sugested, you can set AUTOEXTEND for your current datafile(s) of RB tablespace (I personaly am not a big fan of AUTOEXTEND option, I've seen to many bugs and ORA-600 related to AUTOEXTEND)
    c) resize (increase size of) you curent datafile(s)
    d) if your rollbacks have grown and you don't have OPTIMAL parameter set for them, then SCHRINKing them (and setting OPTIMAL) might free a lot of space in your RB tablespace

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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