Home » Other » Training & Certification » Difference Between "Redo Log Buffer" and "Database Buffer Cache"?
Difference Between "Redo Log Buffer" and "Database Buffer Cache"? [message #264177] |
Sat, 01 September 2007 08:19  |
raksaba
Messages: 1 Registered: August 2007
|
Junior Member |
|
|
Hi,
I am totally new to Oracle.
I just want to know what is the difference between redo log buffer and database buffer cache?
Changes to the rows/columns are stored in database buffer cache and also in redo log buffer.
then what is the necessity to have redo log buffer?
Could anyone please explain with simple example?
|
|
|
|
Re: Difference Between "Redo Log Buffer" and "Database Buffer Cache"? [message #264578 is a reply to message #264177] |
Mon, 03 September 2007 18:37   |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Hi guys
anacedent:
We don’t need to be aggressive, I’m new with Oracle and I’ve read the first chapters of the books and I’ve a lot of doubts. Of course I haven’t all the concepts perfectly clear in my first time.
raksaba:
I was reviewing the concepts a Little bit, and it seems like the Buffer cache is communicated with data files and Redo logs buffers are communicated with redo log files.
I mean: the buffer cache is communicated to a Database Writer process (DBW0) the it says to you that maybe an result of an insert command will be stored in data files (it is the common files where your data is stored) and from the other hand you have the Redo Log buffer that is communicated with the Log Writer process (LGWR) and it write into redo log files I guess because when you haven’t space in your RAM memory you need to save it in the hard disk to have all the changes saved in order to keep it ready for some restore.
I understand your question and I guess you’re thinking in the possibility to use just one buffer and maybe two processes to write in the data file one for data files and another for redo logs files. I don’t know exactly the difference between the two buffers but just think if you are an experimented programmer, always is good to separate one process that do something to another that have other objective.
I guess also that my explanation is not good enough, but is all that I know at moment and I don’t want to be more ahead of it because I’m reading chapter by chapter.
Look up this link:
http://www.exforsys.com/tutorials/oracle-10g/oracle-10g-concepts-and-database-architecture/1.html
Let me know you comments and sorry for my English.
Cheers
Marcos
[Updated on: Mon, 03 September 2007 18:40] Report message to a moderator
|
|
|
|
|
Re: Difference Between "Redo Log Buffer" and "Database Buffer Cache"? [message #266110 is a reply to message #264177] |
Sun, 09 September 2007 15:54   |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Of course, I’m not fighting with everybody.
But in my understood if he have asked it.., if because…he read it at least a few times, people who have this doubt if because have read the documents a few times in my opinion.
And I’ve read 2 times the Oracle.Database.10g.Administration book in the chapter 3 where I’m positioned now and I’ve similar questions, and I need some place where I can explain and share similar questions like that.
For this reason I said that.
Anyway, is obviously and I understand your point “people sometimes don’t want to read one more time or find some additional information before ask”.
In order to finish, something that we have to respect is all the opinions, wrong or not, is very important because everybody can have a mistake.
Marcos
[Edit (MC): remove portuguese sentence]
[Updated on: Sun, 09 September 2007 23:52] by Moderator Report message to a moderator
|
|
|
|
|
Re: Difference Between "Redo Log Buffer" and "Database Buffer Cache"? [message #266114 is a reply to message #264177] |
Sun, 09 September 2007 17:43   |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Ok, anacedent how are you doing?
I’ll explain you in other words, it's my last time.
Just I’m saying you “try to be more friendly with the people”.
You want to everybody think exactly as you’re thinking and it’s no possible, 2 people don’t think equal, maybe similar but not equal . It’s proved psychologically. You can’t try to impose all that you’re thinking. Just give your Best suggestion and try to be friendly.
I want to arrive to my next certification, and I’ll do my better effort and try to follow all the best suggestions, but it has a limit, all of us have a way to work, to learn and do all things.
I don’t know if i’m perfectly clear, let me know.
I don’t agree with you mson77, we have to suggest the people don’t try to impose methods to think.
I’m wrong I apolige and maybe i’ll be out of the f�rum also.
Have a nice week
Marcos
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 13:47:56 CDT 2025
|