| Redo Log Buffer Quick Question [message #672780] |
Fri, 26 October 2018 08:57  |
wtolentino
Messages: 421
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  |
John Watson
Messages: 8960
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 |
wtolentino
Messages: 421
Registered: March 2005
|
Senior Member |
|
|
John Watson wrote on Fri, 26 October 2018 10:04It 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 #672801 is a reply to message #672793] |
Fri, 26 October 2018 12:11 |
wtolentino
Messages: 421
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 #672805 is a reply to message #672804] |
Fri, 26 October 2018 12:31 |
wtolentino
Messages: 421
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
