ALTER SYSTEM CHECKPOINT 影响数据文件的检查点

最新推荐文章于 2024-04-08 06:47:55 发布

原创最新推荐文章于 2024-04-08 06:47:55 发布 · 1.2k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#system #sql

收录于

ORACLE 专栏收录该内容

84 篇文章

订阅专栏

本文通过SQL查询展示了在执行ALTER SYSTEM CHECKPOINT命令前后，数据文件的检查点改变情况。执行该命令导致所有数据文件的checkpoint_change#更新，确保了数据库的一致性状态。

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
2015368

SQL> select name,checkpoint_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/system01.dbf
2015323

/u01/app/oracle/oradata/orcl/undotbs01.dbf
2015323

/u01/app/oracle/oradata/orcl/sysaux01.dbf
2015323

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/users01.dbf
2015323

/u01/app/oracle/oradata/orcl/eygle01.dbf
2015323

SQL> alter system checkpoint;

System altered.

SQL> select name,checkpoint_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/system01.dbf
2015376

/u01/app/oracle/oradata/orcl/undotbs01.dbf
2015376

/u01/app/oracle/oradata/orcl/sysaux01.dbf
2015376

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/users01.dbf
2015376

/u01/app/oracle/oradata/orcl/eygle01.dbf
2015376