Question

如何查询数据文件的当前SCN号

Answer 1

System Checkpoint SCN：
select checkpoint_change# from v$database;
Datafile Checkpoint SCN：
select name,checkpoint_change# from v$datafile;