Max # extents reached for rollback segs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Max # extents reached for rollback segs

  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Max # extents reached for rollback segs

    Hi,
    I had encounter the below error. Can someone pls give your suggestion in order to get rid of the ora-1628 error? Tq

    ORA-1628: max # extents 200 reached for rollback segment R03_HL
    Failure to extend rollback segment 3 because of 1628 condition
    FULL status of rollback segment 3 set.

  2. #2
    Join Date
    Jan 2004
    Posts
    30
    SEGMENT_NAME MAX_EXTENTS PCT_INCREASE OWNER
    --------------- ----------- ------------ ----------
    SYSTEM 2147483645 0 SYS
    R01_HL 200 0 SYS
    R02_HL 200 0 SYS
    R03_HL 200 0 SYS
    R04_HL 250 0 SYS
    R05_HL 200 0 SYS
    R06_HL 200 0 SYS
    R07_HL 200 0 SYS
    R08_HL 200 0 SYS
    R09_HL 250 0 SYS
    R10_HL 300 0 SYS

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    increase the value of MAXEXTENTS
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jan 2004
    Posts
    30
    hi Slimdave,
    is there any alternative beside increate the max_extents?
    Tq

  5. #5
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi samc,

    1. Increase the NEXT parameter of the rollback segment :
    ALTER ROLLBACK SEGMENT rollback_segment STORAGE (NEXT integer);

    2. Increast the MAXEXTENTS storage parameter of the rollback segment:
    ALTER ROLLBACK SEGMENT rollback_segment STORAGE ( MAXEXTENTS integer);

    Regards,
    Nir

  6. #6
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    hi,
    what caused this error?

    a very big transaction or import?

    you can commit in between to minimise the
    size of the transaction.

    -Raja

  7. #7
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    Increase maxextents and specify OPTIMAL.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

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