Question: How the (new/commited) data writes from redo log to user's data file. ? For example: if I update one row in a table and commit it, it will first
goes to log buffer and than LGWR writes log buffer into redolog file . so How the new updated data actually goes to user's data file. ?
This is what I have understand.
Database buffer cache the data block. Server(user) process first read the data from buffer cache.
if server process (user process) doesn't find data into buffer cache, it will read the data from datafile and load into buffer cache and than respond to user's request.
Log buffer hold the all the database changes we made to the database. when transaction occurs, oracle first write chages into log buffer. LGWR writes log buffer to redolog files and when redo log files filled up, ARCH process write data into archive log if database is in ARCHIVE LOG MODE.
Thanks in advance....