相克军_Oracle体系_随堂笔记009-检查点队列

select CPDRT,CPLRBA_SEQ||‘.‘||CPLRBA_BNO||‘.‘||CPLRBA_BOF "LowRBA",CPODR_SEQ||‘.‘||CPODR_BNO||‘.‘||CPODR_BOF "On disk RBA",CPODS,CPODT,CPHBT from x$kcccp;

select checkpoint_change# from v$database;
alter system checkpoint;
alter system switch logfile;
select name,checkpoint_change# from v$datafile ;
select name,checkpoint_change# from v$datafile_header;
select * from v$log;

 create table t2(id int, name varchar2(50));

begin
for i in 1..10000 loop
insert into  t2 values(1,‘xkj‘);
commit;
end loop;
end;

select * from t2;

alter system flush buffer_cache;