Checkpoint time of datafiles - Oracle Database Script. -- REFERENCE - ORAFAQ 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;
-- REFERENCE - ORAFAQ 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;