Good time difference between current database time and last datafile checkpoint time
Hi Oracle Gurus,
I can see quite a lot of difference between my current database/system time and last datafile checkpoint time (column CHECKPOINT_TIME of v$datafile). It's almost 8 minutes as you can see below. Does this mean almost 8 minutes of committed data is lying in my online redo logs without being written to my datafiles? Please find example below for one datafile.
SQL> select a.CHECKPOINT_CHANGE#, b.CURRENT_SCN, to_char(a.CHECKPOINT_TIME, 'DD-MON-YYYY HH:MI:SS') AS last_file_ckpt_time, a.NAME from v$datafile a, v$database b
where a.CHECKPOINT_CHANGE#=b.CHECKPOINT_CHANGE# and a.file#=401;