Re: Log Checkpoint

ccdicky_at_my-deja.com skrev i artiklen <92repa$vc2$1_at_nnrp1.deja.com>...
> Hi there,
>
> I am newbie of Oracle8i. I know the log will be archived out every one
> and half hour by default log checkpoint settings even though the log is
> not full. However, on my development site, due to the space
> constraint, I disable this default by following settings:
>
> log_checkpoint_timeout = 0
> log_checkpoint_interval = 0
>
> And everything remains default. I thought the log should have been
> archived out when the log is got full. But it is not. Can anybody
> tell me what is the right way to disable the log checkpoint. Any input
> would be appreaicated.
>
> Dicky

Hi,

As I read your question you want the log to be archived when full, but not before, is this correct ?
To do that:
set log_checkpoint_interval to a number larger than your redolog size (in number of OS blocks)
set log_checkpoint_interval to zero

From the 8.0 manual:
To have database checkpoints only occur at log switches (the default), set the value for the LOG_CHECKPOINT_INTERVAL parameter higher than the size of the online redo log files in use. The value of the LOG_CHECKPOINT_INTERVAL is a number of operating system blocks, not Oracle data blocks. Therefore, you must know the size, in bytes, of your operating system's blocks. Once you know this, calculate the number of operating system blocks per online redo log file.

To have database checkpoints only occur at log switches (the default), set the value for the LOG_CHECKPOINT_TIMEOUT parameter to zero.

Peter Laursen Received on Tue Jan 02 2001 - 07:05:12 CST