Re: Log Checkpoint

In article <92repa$vc2$1_at_nnrp1.deja.com>,   ccdicky_at_my-deja.com wrote:
> 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
>
> Sent via Deja.com
> http://www.deja.com/
>

You can't. The redo log mechanism is one of the vital features of Oracle.

Regards

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/