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

Thread: Undo Tablespace problem

  1. #1
    Join Date
    Oct 2001
    Posts
    52
    Hi,
    I have set my undo_tbs to 1.2gb. It should be release back the space after the process (that taken 700M) commited, rite?
    But I notice that there are nothing change to reduce the freespace of the undo_tbs. Would it mean that the undo_tbs will keep on increasing? or How to release the space for my undo_tbs ?
    Please advise
    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    it wont get released because it has to use it for flashback queries, it will free when he has to
    if you dont want to use flashback then set undo_retention to 0...

  3. #3
    Join Date
    May 2002
    Posts
    1

    undo

    set the undo_retention to low value and even after the active extent becomes inactive immediately space will not be realeased.

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