set linesize 250;
select v2.ts# as ts_no,
v2.name as ts_name,
file# as file_no,
checkpoint_change# as ckpt_no,
last_change# as last_change
from v$datafile v1, v$tablespace v2
where v1.TS# = v2.TS#
order by v2.TS#, v1.FILE#;
Oracle 数据库查看数据文件检查点信息
最新推荐文章于 2024-05-11 08:31:42 发布