1 Reply Latest reply: Jan 3, 2013 2:10 AM by Jairam RSS

    is undo blocks also got loaded into buffer cache

    951290
      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

      Mahi