有关增量检查点

SQL> select cpdrt dirty,cpods on_disk_scn,cpodt on_disk_time,cphbt from x$kcccp where indx=0;

DIRTY ON_DISK_SCN ON_DISK_TIME CPHBT
---------- ---------------- -------------------- ----------
313 1552809427 07/09/2019 17:48:08 1013197501

SQL> alter system switch logfile;

System altered.

SQL> select cpdrt dirty,cpods on_disk_scn,cpodt on_disk_time,cphbt from x$kcccp where indx=0;

DIRTY ON_DISK_SCN ON_DISK_TIME CPHBT
---------- ---------------- -------------------- ----------
353 1552809515 07/09/2019 17:48:41 1013197533

SQL> alter system checkpoint;

System altered.

SQL> select cpdrt dirty,cpods on_disk_scn,cpodt on_disk_time,cphbt from x$kcccp where indx=0;

DIRTY ON_DISK_SCN ON_DISK_TIME CPHBT
---------- ---------------- -------------------- ----------
0 1552809534 07/09/2019 17:49:01 1013197553

 

 

 

参考：https://blog.csdn.net/robinson1988/article/details/5091248