DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RBS PROBLEM

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55

    Arrow

    ORA-1628: max # extents 121 reached for rollback segment R10
    Failure to extend rollback segment 16 because of 1628 condition
    FULL status of rollback segment 16 set


    ORA-1628: max # extents 121 reached for rollback segment R10
    Failure to extend rollback segment 16 because of 1628 condition
    ORA-1628: max # extents 121 reached for rollback segment R10
    Failure to extend rollback segment 16 because of 1628 condition

    Here I am having rollback segment problem.

    So I resized the rollback segment tablespace.

    again I having the same problem.

    when I run particular transaction and particular user, that time only I am getting this error. not alwyas.

    So what I want to do, please tell me.


    My id is shankar_gk@hotmail.com,
    kgshangs@yahoo.com


    Bye,

    G.shankar.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    you need to increase the max_extents parameter --

    ALTER ROLLBACK SEGMENT "R10" STORAGE ( MAXEXTENTS 500)


    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Nov 2000
    Posts
    344
    you have 2 choices -

    1) alter rollback segment R10 maxextents X
    (where X = some number higher than 121, or 'unlimited'.

    2) drop and recreate the rollback segment like this :
    (obviously, you will have to change the commands a little)

    alter rollback segment RBS1 offline
    /

    drop rollback segment RBS1
    /

    Create Public Rollback Segment RBS1
    Tablespace RBS
    Storage (
    Initial 512K
    Next 512K
    Minextents 8
    Maxextents 4096
    Optimal 4194304
    )
    /

    alter rollback segment RBS1 online
    /

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