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.

  • SMON Process Instance Failure

    How does the SMON process performs recovery after instance failure?

    ranjithsv18

    • Oct 2nd, 2013

    When hardware failure, software failue and shutdown abnormally happen... SMON taking care of Instance failure, coalesce failure space and deallocating temp segment start to recover instance Roll fw...

    Nagaraj OCP

    • Dec 27th, 2011

    When shutdown abort happens, oracle server gets crashed. To recover from the crash, SMON will check the online Redo data files and last SCN no in the Redo log files and SCN number in the undo tablespa...