Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> log_checkpoint_timeout new meaning in 8i
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07661.A8E7D0E6
Content-Type: text/plain;
charset="iso-8859-1"
hello all,
I've got LOG_CHECKPOINT_TIMEOUT set to 1800 (30 minutes) in one of my databases. I also have LOG_CHECKPOINTS_TO_ALERT set to true. However, every morning I look at the archive logs and I see that 1. the logs haven't switched since the nightly batch quit and 2. there are no checkpoints in the alert log since the log switch. This makes me a little nervous.
It seems that LOG_CHECKPOINT_TIMEOUT is not working. However, I find this on metalink that kind of explains it.
The parameter log_checkpoint_timeout has been re-interpreted. In prior releases, every log_checkpoint_timeout seconds, Oracle started an interval checkpoint. Starting with Oracle 8.1, log_checkpoint_timeout will be interpreted to mean that the incremental checkpoint should be at the log position where the tail of the log was log_checkpoint_timeout seconds ago. In other words, the incremental checkpoint should lag the tail of the log by no more than log_checkpoint_timeout seconds worth of redo.
I don't quite understand. Can someone paraphrase this? Does this mean that every LOG_CHECKPOINT_TIMEOUT seconds it makes sure that there is no redo that hasn't been written to disk that is more than LOG_CHECKPOINT_TIMEOUT seconds old? In other words, it checks to see if a checkpoint is necessary instead of just doing it?
Thanks
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
------_=_NextPart_001_01C07661.A8E7D0E6
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>log_checkpoint_timeout new meaning in 8i</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">hello all, </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I've got LOG_CHECKPOINT_TIMEOUT set to =
1800 (30 minutes) in one of my databases. I also have =
LOG_CHECKPOINTS_TO_ALERT set to true. However, every morning I =
look at the archive logs and I see that 1. the logs haven't switched =
since the nightly batch quit and 2. there are no checkpoints in the =
alert log since the log switch. This makes me a little nervous. =
</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial"> It seems that =
LOG_CHECKPOINT_TIMEOUT is not working. However, I find this on =
metalink that kind of explains it. </FONT>
</P>
<P><FONT FACE=3D"Times New Roman">The parameter log_checkpoint_timeout =
has been re-interpreted. In prior releases, every =
log_checkpoint_timeout seconds, Oracle started an interval checkpoint. =
Starting with Oracle 8.1, log_checkpoint_timeout will be interpreted to =
mean that the incremental checkpoint should be at the log position =
where the tail of the log was log_checkpoint_timeout seconds ago. In =
other words,<B> the incremental checkpoint should lag the tail of the =
log by no more than log_checkpoint_timeout seconds worth of redo. =
</B></FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I don't quite understand. Can =
someone paraphrase this? Does this mean that every =
LOG_CHECKPOINT_TIMEOUT seconds it makes sure that there is no redo that =
hasn't been written to disk that is more than LOG_CHECKPOINT_TIMEOUT =
seconds old? In other words, it checks to see if a checkpoint is =
necessary instead of just doing it? </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks</FONT>
</P>
<P><B><FONT SIZE=3D1 FACE=3D"Arial">Lisa Rutland Koivu</FONT></B>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Qode.com</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">4850 North State Road 7</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Suite G104</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Fort Lauderdale, FL =
33319</FONT>
</P>
<P><FONT SIZE=3D1 FACE=3D"Arial">V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">C: 954.658.5849</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial"><A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
</P>
<P><I><FONT COLOR=3D"#000000" SIZE=3D1 FACE=3D"Arial">"The =
information contained herein does not express the opinion or position =
of Qode.com and cannot be attributed to or made binding upon =
Received on Thu Jan 04 2001 - 09:18:58 CST
![]() |
![]() |