Hi, you seem to be mixing it up with the database buffer cache(db_block_buffer) in the SGA. The needed database blocks are in this database buffer cache. Whereas, the redo log buffer has the changes made to this database blocks in the database buffer cache.
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............
So for datafiles we have buffer cache....
in the same way, for writing into online redo logfiles it has to be done in the memory...right....so where in the memory.....
As Oracle 9i Administrator Guide said, Redo file are filled with redo records, each of which is a description of a change made to a single block in the database. How does Logminer reconstruct the DML statement in SQL_REDO?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998