v$datafile_header

v$datafile_header contains various information about data file headers.

Determine last checkpoint

Determine the last checkpoint (SCN and corresponding timestamp) for each data file:

select
  substr(name, 1, 100)                              data_file,
  checkpoint_change#                                scn,
  to_char(checkpoint_time, 'dd.mm.yyyy hh24:mi:ss') date_
from
  v$datafile_header;

Github repository oracle-patterns, path: /Installed/dynamic-performance-views/datafile/header/last-checkpoint.sql

v$datafile_header

Determine last checkpoint

See also