From: sybrandb@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Log Checkpoint
Date: Tue, 02 Jan 2001 05:44:31 GMT
Organization: Deja.com
Lines: 39
Message-ID: <92rpru$7d4$1@nnrp1.deja.com>
References: <92repa$vc2$1@nnrp1.deja.com>
NNTP-Posting-Host: 213.116.132.97
X-Article-Creation-Date: Tue Jan 02 05:44:31 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; Parool INTERNET)
X-Http-Proxy: 1.1 x67.deja.com:80 (Squid/1.1.22) for client 213.116.132.97
X-MyDeja-Info: XMYDJUIDsybrandb


In article <92repa$vc2$1@nnrp1.deja.com>,
  ccdicky@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/