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 -> Checkpoint duration

Checkpoint duration

From: <timur.gokce_at_gmail.com>
Date: 26 Nov 2006 16:16:40 -0800
Message-ID: <1164586600.800418.55890@45g2000cws.googlegroups.com>


Checkpoint process updates the file headers of the data files and flushes the dirty buffers in cache to data files.

i) Is there any propotional relation between "number of datafiles" and time spent to perform a checkpoint ?
ii) Is the majority of the time spent to checkpoint caused by "header update"(LGWR) or "flushing dirty buffers"(DBWR) ? Received on Sun Nov 26 2006 - 18:16:40 CST

Original text of this message

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