what are you tallking about?Quote:
Originally posted by Sonia
who will read the blocks from Redolog file to the redo log buffer ?
Printable View
what are you tallking about?Quote:
Originally posted by Sonia
who will read the blocks from Redolog file to the redo log buffer ?
Hi Sonia
I think you are completely confused about the working of the redo log buffer, LGWR and online redo logs. Refer the online help that comes with Oracle software. This will clear most of your doubts. Anyhow let me try to explain something
As users perform transactions (updates, inserts, deletes), the redo buffer (a part of the oracle SGA in MAIN MEMORY) fills up. After that, based on certain conditions like a timeout or commit the redo buffer entries are written from the redo buffer to the online redo logs (on DISK) by an Oracle background process called LGWR. Once the online redo logs are filled, they may or may not be archived based on the mode in which your database is operating.
Burzin.
Right, forget about oracle, any software for that matter - how could any write operation ever be done in memory???? (Of course, disk controlers write cache does not count here.)Quote:
Originally posted by Sonia
[B]What i am telling is, any data that has to be wrtten to the file it has to be done in the memory...right...forget abt oracle......any software for that matter............
Changes are performed in memory, physical writes must allways be performed on disk. Writes are permanent operations, it means changes are permanently stored somewhere where they are safe - RAM is certainly not such media.
There is no such thing as "write to file performed in memory".