Database Tuning (MOSC)

MOSC Banner

Good time difference between current database time and last datafile checkpoint time

edited Aug 28, 2015 10:05AM in Database Tuning (MOSC) 12 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center