分别insert ,update ,delete ,truncate 数据,比较归档和闪回的大小。
11.2
linux
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 42]$du -sk ./*
8 ./archivelog
8 ./backupset
9548 ./controlfile
8 ./datafile
8 ./flashback
8 ./onlinelog
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 43]$pwd
/opt/flash_recovery_area/TEST3
SQL> select sum(bytes)/1024/1024/1024 g from dba_segments s
2 where s.owner='TEST' AND S.segment_name='T1';
G
----------
1.875
---------update
update :归档日志产生表大小的2倍多一点。 闪回日志是归档日志的一半多一点。
SQL> update test.t1 t set t.owner=test;
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 48]$du -sk ./*
4375724 ./archivelog
8 ./backupset
9548 ./controlfile
8 ./datafile
2344696 ./flashback
8 ./onlinelog
SQL> delete from test.t1;
delete :归档日志产生不到2倍。 闪回日志是归档日志的1/3。
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 56]$du -sk ./*
3484740 ./archivelog
8 ./backupset
9548 ./controlfile
8 ./datafile
1107152 ./flashback
8 ./onlinelog
SQL> truncate table test.t1;
truncate :归档没有,闪回产生极少
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 46]$du -sk ./*
8 ./archivelog
8 ./backupset
9548 ./controlfile
8 ./datafile
4024 ./flashback
8 ./onlinelog
insert :,闪回产生很少,归档1倍多。
begin
for i in 1..10 loop
insert into test.t1 select * from TEST.T1;
commit;
end loop;
end;
SQL> select sum(bytes)/1024/1024/1024 g from dba_segments s
2 where s.owner='TEST' AND S.segment_name='T1';
G
----------
1.5
[op11g@localhost IP=30 /opt/flash_recovery_area/TEST3 34]$du -sk ./*
2468528 ./archivelog
8 ./backupset
9548 ./controlfile
8 ./datafile
8032 ./flashback
8 ./onlinelog
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10113559/viewspace-715164/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10113559/viewspace-715164/