OraFAQ Forum: Server Administration » Redo log information

Home » RDBMS Server » Server Administration » Redo log information

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Redo log information [message #377490]

Tue, 23 December 2008 04:13

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi all,

My understanding is that the database buffer cache and the redo log buffer are two separate memory ares of the SGA.

Database buffer cache contains modified and unmodified data wheareas log buffer contains committed and uncommited data.

Server processes performing DML operations create undo blocks and make changes to data blocks in the database buffer cache.

Can anybody explain how the appropriate redo information from these changes makes its way into the redo log buffer. Does the user's server process write the changes to the database buffer cache and to the redo log buffer at the same time?

Thanks in advance

Regards,
Balaji

Report message to a moderator