文档介绍：Oracle数据库表空间对应CHECKPOINT的变化
用实验来说话。
Microsoft Windows [版本 ]
版权所有(c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\LIUBINGLIN>
C:\Users\LIUBINGLIN>sqlplus / as sysdba
SQL*Plus: Release Production on 星期一 12月 10 21:54:36 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release - Production
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production
SQL> archive log list;
数据库日志模式非存档模式
自动存档禁用
存档终点 F:\app\oracle\product\\dbhome_1\RDBMS
最早的联机日志序列 27
当前日志序列 28
SQL> select file_id,tablespace_name,file_name from dba_data_files;
FILE_ID TABLESPACE_NAME
---------- ------------------------------
FILE_NAME
--------------------------------------------------------------------------------
5 CACHETBLSP
F:\APP\ORACLE\ORADATA\ORCL\
4 USERS
F:\APP\ORACLE\ORADATA\ORCL\
3 UNDOTBS1
F:\APP\ORACLE\ORADATA\ORCL\
FILE_ID TABLESPACE_NAME
---------- ------------------------------
FILE_NAME
--------------------------------------------------------------------------------
2 SYSAUX
F:\APP\ORACLE\ORADATA\ORCL\
1 SYSTEM
F:\APP\ORACLE\ORADATA\ORCL\
6 TEST
F:\APP\ORACLE\ORADATA\ORCL\
FILE_ID TABLESPACE_NAME
---------- ------------------------------
FILE_NAME
--------------------------------------------------------------------------------
7 TEST
F:\APP\ORACLE\ORADATA\ORCL\
已选择7行。
SQL> select checkpoint_change# from v$database;