FAQ
I have a question about Oracle internal processing of commit.

Here is excerpt from Oracle wits evenst description:

log file sync

When a user session commits, the session's redo information needs to be
flushed to the redo logfile. The user session will post the LGWR to
write the log buffer to the redo log file. When the LGWR has finished
writing, it will post the user session.

I find it difficult to believe Oracle maintains redo sub-buffers for
every session, does it?
As far as I understand, LGWR will write the whole redo buffer up to the
commit SCN but not "the session's redo information" as the description
states.



Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

Search Discussions

  • Alex Gorbachev at May 3, 2006 at 6:36 pm
    The best description of redo mechanism I ever read -
    http://www.ixora.com.au/notes. Check redo section there. If I remember
    correctly it's relevant to 8i but all of it it valid for 9i/10g with
    some additions and improvements.

    2006/5/3, Laimutis Nedzinskas :
    I have a question about Oracle internal processing of commit.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 3, '06 at 1:51p
activeMay 3, '06 at 6:36p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase