Re: Linux--Oracle Control File Errors

David Sisk wrote in message ...
>Hi:
>
>My best guess is that there is contention for the control file header
>because another checkpoint is occuring before the first one finished.
>Checkpoints are triggered by two things during normal operation: Number of
>bytes written, and elapsed time. Try modifying the following init.ora
parms:
>
>1) log_checkpoint_interval: This is in bytes, so set it larger than your
>redo log files. (You might also want to make your redo log files larger
>first. 10-50Mb or even larger is not an unusual setting.) If you set this
>parm larger than your redo log file size, then you will only get a
>checkpoint on each redo log switch. Now you're getting a checkpoint every
>99K bytes, unless your redo logs are 99K or smaller.
>

log_checkpoint_interval is the number of redo log file blocks (operating-system blocks,
not database blocks or bytes)

>2) log_checkpoint_timeout: This is in seconds (I believe), so set it such
>that you get a checkpoint every 30 minutes or hour, etc.
>

log_checkpoint_timeout is in seconds, set it to zero and timeout-based checkpoints
can be disabled.

Just wanted to make this clear.
Mike Quist, OCP Database Administration Received on Mon Nov 16 1998 - 12:08:05 CST