LGWR Archives -

Oracle Architecture Part 4

19/09/201323/10/2012 by Philip

[embedplusvideo height=”328″ width=”584″ standard=”http://www.youtube.com/v/nNGLyWIPPTQ?fs=1″ vars=”ytid=nNGLyWIPPTQ&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=&notes=” id=”ep8443″ /] Watch the earlier parts first: Part 1 Part 2 Part 3 Notes: Oracle Processes Dbwr Database Writer Writes from the SGA to the data files Does deffered writes like a hotel room clerk kicks blocks out to disk when new data needs free blocks Lgwr Log …

The Oracle Redo Log

01/02/201411/10/2012 by Philip

One of the most important ideas in Oracle is that your data is safe. It is protected from corruption and also from system crashes. One of the most important ways that it does this is through the Redo logs. A Redo log record is written to describe the changes every time some data is changed …