Home » Other » General » Redo Log Buffer Quick Question (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0)
Redo Log Buffer Quick Question [message #672780] Fri, 26 October 2018 08:57 Go to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
The log writer LGWR is the background process that transfers all undo and redo entries in the log buffer to the redo log files. What is the server or background process that puts the undo and redo entries to the Redo Log Buffer.

Thanks,
Warren
Re: Redo Log Buffer Quick Question [message #672782 is a reply to message #672780] Fri, 26 October 2018 09:04 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
transfers all undo and redo entries in the log buffer to the redo log files
No! Redo is change vectors applied to blocks: table blocks, index blocks, undo blocks, all sorts of blocks. A change to an undo block is no different to a change to any other type of block.


Quote:
What is the server or background process that puts the undo and redo entries to the Redo Log Buffer.
It is the session server process: the process that is doing your DML.
Re: Redo Log Buffer Quick Question [message #672789 is a reply to message #672782] Fri, 26 October 2018 10:30 Go to previous messageGo to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
John Watson wrote on Fri, 26 October 2018 10:04
It is the session server process: the process that is doing your DML.

thanks. is that the same as the client process or differrent process. i was looking at the oracle 12c database architechture diagram (print) but could not find it.

[Updated on: Fri, 26 October 2018 10:34]

Report message to a moderator

Re: Redo Log Buffer Quick Question [message #672790 is a reply to message #672789] Fri, 26 October 2018 10:31 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The client process is not the same as the server process.
Re: Redo Log Buffer Quick Question [message #672791 is a reply to message #672790] Fri, 26 October 2018 10:44 Go to previous messageGo to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
thank you. can you help point exactly what is that process in the oracle 12c database architecture diagram. for example LGWR, CKPT, DBWr, ARCHn.
Re: Redo Log Buffer Quick Question [message #672793 is a reply to message #672791] Fri, 26 October 2018 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Concepts, Chapter 15 Process Architecture.

Re: Redo Log Buffer Quick Question [message #672801 is a reply to message #672793] Fri, 26 October 2018 12:11 Go to previous messageGo to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
thanks Michel. yes I looked up also into that documentation prior to posting my question in here and re-read it again. maybe I a missing something or not fully understand the terminology and still could not find that "session server process" that John Watson mentioned.
Re: Redo Log Buffer Quick Question [message #672804 is a reply to message #672801] Fri, 26 October 2018 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In the red square in the image taken from the page I pointed you to.

/forum/fa/13960/0/

  • Attachment: orafaq.png
    (Size: 27.88KB, Downloaded 3224 times)
Re: Redo Log Buffer Quick Question [message #672805 is a reply to message #672804] Fri, 26 October 2018 12:31 Go to previous message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
thanks so much now I understand. it was not something that i thought there's a "session server process" that is totally different from the "server process". the 2 can be sometimes interchangeably called.
Previous Topic: Automatic Storage Management (ASM) auto create datafile
Next Topic: XE 18c is here
Goto Forum:
  


Current Time: Thu Mar 28 10:06:40 CDT 2024