1 Reply Latest reply on Jan 3, 2013 8:10 AM by Jairam

    is undo blocks also got loaded into buffer cache

      hi gurus,

      i am a beginner in oracle dba . I have read sql processing steps in oracle , in which i noticed one thing during dml operation oracle reads undo blocks along with data blocks into
      database buffer cache. Whats the purpose of loading undo image into buffer cache?? as it is already in undo tablespace. Also please guide me what happens to undo blocks after commit.

      any help appreciated .

      Thanks in advance