Oracle is not releasing the UNDO space even after shutdown and start
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle is not releasing the UNDO space even after shutdown and start

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Oracle is not releasing the UNDO space even after shutdown and start

    Hi All,

    I am getting this error ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

    We tried this to shutdown and restart.

    Oracle is not releasing the UNDO space even after shutdown and start

    Can you pelase help.

    Thanks indavance.
    Cheers!
    OraKid.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    perhaps you need to extend your undo tablespace to account for the room your app needs

  3. #3
    Join Date
    Aug 2002
    Posts
    56
    What is your db version. If its 9i what is your undo_retention setting? you can try decresing the undo_retention and then use the oradebug wakeup
    When in doubt ...go to the basics!!

  4. #4
    Join Date
    Sep 2007
    Posts
    2
    Qustions for you
    -> What is your undo tablespace size ?
    -> What is your undo_retention setting ?

    Thanks
    NM
    "DBA by Choice"

  5. #5
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Debug the SQL that is causing the error to occur.

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