This discussion is archived
8 Replies Latest reply: Oct 30, 2013 11:36 AM by jgarry RSS

What does INSERT do exactly ?

1001135 Newbie
Currently Being Moderated

Hello DBAs experts,

 

Insert into toto values ( 1,2,3);

To simplify :

        1) LGWR write in current redolog

        2) DBWR write on datafile

        3) Oracle ( which process?) write on UNDO

That's right ?

and when the user execute "commit" what happen in addition to these steps ? update SCN in the header block containing this inserted row ? free undo ? how tell the redolog that this insert is committed ? ....

 

Many thanks in advance.

 

 

 


Legend

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