From: ccdicky@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Log Checkpoint
Date: Tue, 02 Jan 2001 02:35:22 GMT
Organization: Deja.com
Lines: 20
Message-ID: <92repa$vc2$1@nnrp1.deja.com>
NNTP-Posting-Host: 202.45.87.203
X-Article-Creation-Date: Tue Jan 02 02:35:22 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.1 x55.deja.com:80 (Squid/1.1.22) for client 202.45.87.203
X-MyDeja-Info: XMYDJUIDccdicky


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/