当插入一条记录时,对应的数据会存放在哪里?
insert into tab_1 values('jjkkll');
strings redo01.log| grep jjkkll;strings redo02.log| grep jjkkll;strings redo03.log| grep jjkkll
commit;无
strings redo01.log| grep jjkkll;strings redo02.log| grep jjkkll;strings redo03.log| grep jjkkll有
strings app01.dbf | grep jjkkll 无
alter system checkpoint
strings app01.dbf | grep jjkkll 有
说明:
insert 数据还在内存中。
commit 数据写入log中。
checkpoint 数据写入数据文件。
阅读(1618) | 评论(0) | 转发(0) |