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

Thread: An Oracle Question

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    Exclamation

    Hi all,
    I'm new to oracle, I've an oracle question that I would like to ask all of you. I was reading some Oracle materials and Im quite confused about the differences between redo log buffer and rollback segments. By the look of its description, both of them seem to have similar tasks... can anyone plse tell me the differences between the two?...are they related at all?? ...thanks in advance...
    Very confused,
    newbie

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    redo log buffer :stores the changes made to the data blocks in memory and when certain trigerring event occurs its content are flushed to the online redo log files on the disk.

    rollback segments:contain before image of the data

    lemme explain with an example

    when you say

    update emp
    set dept=cia
    where name='kelly';

    the value of the rows containing kelly as the name before making this change are copied to the rollback segments.

    when the changes are finally made these are written to the redo buffer.

  3. #3
    Join Date
    Jul 2000
    Posts
    119
    Well , here is some more explaination ...as per the oracle documentation says , the before and after images are witten to the redo logs .once the redo logs have been applied in recovery process , and this means recovering the rollback segment entries in the buffer cache that may have been lost in a database crash -the rollback segments are applied-but the UNDO informati0on comes from the redo logs firtst .So the redo logs contains both undo and redo information .
    Hope that doesn's confuse .
    OCP 8.0, 8i, 9i

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