Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Oracle ARIES implementation

Laimutis Nedzinskas

2006-05-03

Replies:

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
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.