-- #############################################################################################
--
-- %Purpose: Show last Checkpoints in the File Headers
--
-- #############################################################################################
--
ttitle  left    'Output generated by: ' sql.user ' at: ' format a8 datum -
skip -
skip -
left  'Show last Checkpoints in the File Headers' -
skip -
left  'Oracle Version ' format a15 sql.release -
skip 2
set feed off
set pagesize 10000
set linesize 500
break on grantee skip 1
column datum new_value datum noprint
column file_nr format 999999 heading 'File#'
column checkpoint_time format A20 heading 'Checkpoint|Time'
column file_name format A59 heading 'Filename'

select FILE# file_nr,
       to_char(CHECKPOINT_TIME,'DD.MM.YYYY:HH24:MI:SS') checkpoint_time,
       name file_name
 from v$datafile_header;