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 -> Re: interaction between LGWR and DBWR

Re: interaction between LGWR and DBWR

From: Jared Hecker <jared_at_pandora.planet.net>
Date: 14 May 1998 12:44:14 GMT
Message-ID: <6jeouu$3l9@jupiter.planet.net>


No, LGWR flushes much more frequently. DBWR only flushes when a certain amount oof it's buffers are dirty, or it needs more-than--clean-buffers-available to satsify a query.

hth

jh

Umar FArooq (umar.farooq_at_cressoft.com.pk) wrote:
: Can someone please tell me how LGWR and DBWR interact...do they flush
: their respective buffers simultaneously....what happens if DBWR has
: flushed the data and the system crashes before LGWR could flush the redo
: buffer...is such a scenario possible?

: Thx.

: Umar Farooq Ch.
: umar.farooq_at_cressoft.com.pk

--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **
Received on Thu May 14 1998 - 07:44:14 CDT

Original text of this message

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