Online Redo logs
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Online Redo logs

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    Online Redo logs

    Hi,
    Whenever any changes has to be written to Online Redo log files, that has to be done in the memory; where does that happen. Does it happen somewhere in OS buffers

    Regards

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    redo log buffer in SGA. LGWR writes from redo log buffer to redo log file.

    The following could be useful...

    http://otn.oracle.com/docs/products/...inere.htm#3848


    HTH.
    Last edited by ggnanaraj; 11-01-2002 at 01:55 AM.

  3. #3
    Join Date
    Feb 2002
    Posts
    267
    Do u mean to say it reads the blocks and puts in log buffer and does the modification.......and again writes them back to disk......?

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

    Check this out...

    http://otn.oracle.com/docs/products/...intro.htm#7179

    Hope this clears it out.
    Last edited by ggnanaraj; 11-01-2002 at 02:07 AM.

  5. #5
    Join Date
    Feb 2002
    Posts
    267
    Hello....hth,
    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.....

  6. #6
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by Sonia
    in the same way, for writing into online redo logfiles it has to be done in the memory...right....so where in the memory.....
    REDO LOG BUFFER IN THE MEMORY.

    Cheers.

    P.S.: It would do you good if you could read throu' the links I posted. In the 2nd link, there is a very good pictorial representation of what we are discussing.
    Last edited by ggnanaraj; 11-01-2002 at 02:15 AM.

  7. #7
    Join Date
    Feb 2002
    Posts
    267
    who will read the blocks from Redolog file to the redo log buffer ?

  8. #8
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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

  9. #9
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by Sonia
    who will read the blocks from Redolog file to the redo log buffer ?
    Nobody. Why should anybody do that?
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  10. #10
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Originally posted by Calvin_Qiu
    How does Logminer reconstruct the DML statement in SQL_REDO?
    Done, it will reconstructe one statement for every record changed.
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width