log_checkpoint_timeout : what is exactly the meaning ?

Hi all,

In my init.ora, the only two parameters about checkpoints are the following :

log_checkpoint_timeout = 900
log_checkpoints_to_alert=true

Shouldn't I observe in the alert file the beginning of a new checkpoint every 15 minutes ? Apparently checkpoints behave as if I had not set the log_checkpoint_timeout, i.e. checkpoints are launched only when a redo log switch occurs. As my redo logs are 200Mb wide, there can be a very long time before a redo log switch occurs, in case of low traffic on the database.

Have I misunderstood the signification of this parameter (I mean log_checkpoint_timeout ) ?

Thanks in advance. Received on Thu May 30 2002 - 11:13:35 CDT