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

Thread: Undo segment

  1. #1
    Join Date
    Aug 2005

    Undo segment

    I have a question and i really confused with it

    What does Undo segments contain?. I know it contains the old values till the transaction is committed. Does it contain the newly updated values along with the old values till it is commited? and what else it contains..


  2. #2
    Join Date
    Sep 2002
    it contains the old values so that a read consistent view can be provided

    changes to the data are store in the redo logs

  3. #3
    Join Date
    Sep 2005
    Undo Segments contains old values which will allow to rollback transaction, provide read consistancy and to recover the database.

  4. #4
    Join Date
    Sep 2005
    undo segments contain pre image or old data and it remains in these segments till another coming entry will not force it to room out, if there is no space in segments. Undo segments provide:

    1. Transaction Recovery (at the time of instance recovery )

    2. Transaction Rollback (if the transaction is rollbacked, pre image or old data is stored from undo segments.)

    3. Read Consistency (when the data is modified in database buffer cache by any DML, its pre image or old data is stored in undo segments, because it is not commited yet, so that users other than the session firing DML could access old data.)

    Undo segments didn't contain new data, but both new and old image is stored in redolog files.
    Last edited by dhar_kiran; 09-09-2005 at 01:34 AM.

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