Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can a large log buffer cause data loss?

Can a large log buffer cause data loss?

From: Magnus Bergh <magnusb_at_sbbs.se>
Date: Tue, 21 Sep 1999 09:42:25 +0200
Message-ID: <MPG.12515543fe23ecbf98969e@news.sbbs.se>


hI am not so sure about how the log_buffer parameter works. Does the buffer work as a cache (wait to write until log buffer is full or some other criteria) or is it used to avoid wait when the LGWR process is busy writing to log files.

if log buffers is used as a cache, couldn't this cause data loss if the Oracle instance crash? Then all buffers in the cache would be lost. I hope and don't think it is this way, but I want to be sure.

Magnus Received on Tue Sep 21 1999 - 02:42:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US