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

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.

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,

>

>

>

>