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