This discussion is archived
1 Reply Latest reply: Jan 3, 2013 12:10 AM by Jairam RSS

is undo blocks also got loaded into buffer cache

951290 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points