Oracle 数据库查看数据文件检查点信息

set linesize 250;
select v2.ts#             as ts_no,
       v2.name            as ts_name,
       file#              as file_no,
       checkpoint_change# as ckpt_no,
       last_change#       as last_change
  from v$datafile v1, v$tablespace v2
 where v1.TS# = v2.TS#
 order by v2.TS#, v1.FILE#;