Answered Questions

  • Redo-log Buffer

    When does the LGWR writes all redo-enteries to the redo-log buffer?

    Suresh

    • Oct 31st, 2017

    1) When user hits commit
    2) When there is 1/3rd full in redo log cache
    3) One every 3 seconds

    During this above situation LGWR writes redo log entries into redo log files from redo log cache !!

    Mayur Pimpalkar

    • Dec 24th, 2015

    Lwgr process writes redo entries to online redolog files not to redobuffer.