Errores y bugs relacionados con el LGWR (Log Writer Process)

Algunos issues relacionados con el Log Writer y notas asociadas:

Redo log entries are generated in the redo log buffer of the system global area (SGA). LGWR writes the redo log entries sequentially into a redo log file. If the database has a multiplexed redo log, then LGWR writes the redo log entries to a group of redo log files.

Issues Specific to LGWR

Note 470.1 - Error ORA-00470: LGWR process terminated with error

Note 431246.1 - Pmon terminated instance due to LGWR termination ORA-470

Note 1089733.1 - ORA-00494: enqueue [CF] held for too long (more than 900 seconds); LGWR:Terminating Instance Due to Error 2103

Note 9556189.8 - Bug 9556189 - LGWR hangs for long periods using DNFS - CF waits likely

Note 6193945.8 - Bug 6193945 - High LGWR CPU use and long 'log file sync' latency in RAC

Note 6074620.8 - Bug 6074620 - LGWR unconditionally writes to trace file

Note 5896963.8 - Bug 5896963 - High LGWR CPU and longer "log file sync" with fix for bug 5065930

Note 5118272.8 - Bug 5118272 - Instance crash with ORA-600 [1433], [60] due to lgwr filling up msg blocks (Messages could be for LGWR or ARCH)

Note 813473.1 - LGWR Uses Async I/O Inspite Of Setting _lgwr_async_io=False

Note 1278149.1 - Intermittent Long 'log file sync' Waits, LGWR Posting Long Write Times, I/O Portion of Wait Minima