Re: Is it the "end of log" or "end of log file"?

Jonathan Lewis wrote:

> I think there is a difference in intent here, and your
> first comment is correct.
>
> The end of the log file is a specific fixed location.

Yes, at begining I was thinking the Certification got an error, but with further thinking, if it is the "end of log", WHAT is the difference for INTERVAL between 8i and 8 (and ealier)??? It looks like they are the same meaning, use the different way to explain it. Regards,

>
> The 'end of log' is presumably supposed to
> indicate the current position in the current log file
> adjusted by the volume of log buffer still waiting
> to be written.
>
> The log_checkpoint_interval is the number of
> redo blocks (not O/S blocks, although redo blocks
> tend to match the O/S blocks), that the incremental
> checkpoint is allowed to trail behind the current log
> position before Oracle starts writing data blocks from
> the end of the checkpoint queue(s). By default the
> log_checkpoint_interval is 90% of the smallest logfile.
> (as at 8.1)
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminars
> UK June / July
> Australia July / August
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Y wrote in message <3CFC27AB.5174FC19_at_y.y>...
> >I find the following in OCP - Oracle8i DBA:
> >LOG_CHECKPOINT_INTERVA -
> >The checkpoint position in the redo log file cannot lag behind the end
> >of the log file by more than the number of OS blocks specified by this
> >parameter.
> >
> >I think it should be "the end of log", not "the end of log file". In
> >Oracle, "the end of log" is the same thing as "the end of log file"???
> >
> >Regards,
> >
> >
> >
> >
Received on Mon Jun 10 2002 - 22:24:44 CDT