实验: Oracle中表shrink与move产生redo日志比较
来源:互联网 发布:php优劣是什么 编辑:程序博客网 时间:2024/05/22 17:13
SQL> create table my_objects_move tablespace ASSM as select * from all_objects where rownum < 20000;
Table created
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
2317832
SQL> delete from my_objects_move where object_name like '%C%';
7546 rows deleted
SQL> delete from my_objects_move where object_name like '%U%';
2959 rows deleted
SQL> commit;
Commit complete
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
6159912
SQL> alter table my_objects_move move;
Table altered
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
7265820
SQL> select (7265820 - 6159912) / 1024 / 1024 "redo_size(M)" from dual;
redo_size(M)
------------
1.0546760559
2 shrink时实验
SQL> create table my_objects tablespace ASSM as select * from all_objects where rownum < 20000;
Table created
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
2315104
SQL> delete from my_objects where object_name like '%C%';
7546 rows deleted
SQL> delete from my_objects where object_name like '%U%';
2959 rows deleted
SQL> commit;
Commit complete
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
6157428
SQL> alter table my_objects enable row movement;
Table altered
SQL> alter table my_objects shrink space;
Table altered
SQL> select value
2 from v$mystat, v$statname
3 where v$mystat.statistic# = v$statname.statistic#
4 and v$statname.name = 'redo size';
VALUE
----------
11034900
SQL> select (11034900 - 6157428) / 1024 / 1024 "redo_size(M)" from dual;
redo_size(M)
------------
4.6515197753
3 结论
move时产生的日志比shrink时少.
- 实验: Oracle中表shrink与move产生redo日志比较
- 实验: Oracle中表shrink与move后index的状态
- 实验: Oracle中表shrink与move后index的状态
- 测试4——shrink和move产生的redo log量的比较
- oracle shrink space 与move
- move和shrink的原理和redo的产生 ,利用rowid的含义实用block个数
- Oracle数据库减少redo日志产生方式
- shrink space产生大量日志
- 降低HWM方法实验move shrink
- 比较Oracle中的alter table t move和alter table t shrink space
- oracle nologging什么场景才能减少redo日志的产生
- Oracle Move和Shrink表空间
- alter table move与shrink space
- alter table move与shrink space
- alter table move与shrink space
- oracle redo日志恢复
- ORACLE REDO 日志调整
- Oracle中REDO日志
- 【转载】java中使用LinkedList类的实例
- XML和TLV打包解包性能比较
- 为什么一份工作要做三年?
- cocos2d-x 获取摄像头
- JavaME UI设计之透明图片处理
- 实验: Oracle中表shrink与move产生redo日志比较
- JavaME UI设计之资源优化技巧
- linux设备驱动--HelloWorld
- JavaME UI设计之点阵字体
- 手机号码判断函数
- JavaME UI设计之Bitmap字体
- JavaME UI设计之图像特效一
- JavaME UI设计之图像特效二
- Debian 6 重新编译增加substitutions_filter模块