Home » RDBMS Server » Server Administration » Redo log information
Redo log information [message #377490] Tue, 23 December 2008 04:13 Go to next message
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

Re: Redo log information [message #377506 is a reply to message #377490] Tue, 23 December 2008 05:05 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/onlineredo.htm#i1007497

Babu
Re: Redo log information [message #377537 is a reply to message #377490] Tue, 23 December 2008 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once more I point you to Database Concepts.
You should really read it.

Regards
Michel
Re: Redo log information [message #377563 is a reply to message #377537] Tue, 23 December 2008 09:03 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks to babu and michel for providing useful links on database concepts.

it was very useful.

With Regards,
Balaji
Previous Topic: Segment shirnk
Next Topic: Bringing database to mount state
Goto Forum:
  


Current Time: Sat Dec 10 18:49:48 CST 2016

Total time taken to generate the page: 0.12109 seconds