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

Thread: rollback tablespace not enough

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    rollback tablespace not enough

    Database error 1562 at UPD access to table ZPSIDG
    > ORA-01562: failed to extend rollback segment number
    > 28#ORA-01650: unable to extend rollback segment PRS_27 by 26
    > in tablespace PSAPROLL#


    hmm, i may wrote this where pple may seem silly, but isnt rollback tablespace dynamic, which means it will shrink and expand according to the growth of transactions?

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    What is the storage parameter for the tablespace? Unlimited? Probably not.

    ORA-01650: unable to extend rollback segment %s by %s in tablespace %s
    Cause: Failed to allocate extent for the rollback segment in tablespace.
    Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.

    Error: ORA 1562 Text: failed to extend rollback segment (id = %s)
    --------------------------------------------------------------------
    Cause: Failure occurred when trying to extent rollback segment Action: This is normally followed by another error message that caused the failure. Shutdown, restart and then take appropriate action for the error the caused the failure. If starting up the system again doesn't solve the problem, it is possible that there is an active transaction in the rollback segment and the system can't roll it back for some reason(s). Check the trace file generated by the PMON process for more information.
    Last edited by stecal; 03-25-2003 at 09:24 PM.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    u may handle in application for avoiding such errors....

    commit regularly in PL/SQL that involves huge TRAN

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    currently, my rollback tablespace is over 15gb. i dont really understand this. since this rollback thing will shrink and grow accordingly to transactions. then when these transactions have committed, why space is not released and instead we have to keep adding data files?

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by abhaysk
    u may handle in application for avoiding such errors....

    commit regularly in PL/SQL that involves huge TRAN

    Abhay.
    why would u ever want to frequently commit in a pl/sql loop?
    You significantly increase the chance of ora-1555 and put the brakes
    on performance

    steve
    I'm stmontgo and I approve of this message

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