1.建立查询redo、undo大小的视图:
2.创建基于session与事务的临时表
3.insert操作生成日志大小测试
select * from v_measure_redo_undo_size;
SQL> select * from v_measure_redo_undo_size;
NAME VALUE
---------------------------------------------------------------- ----------
redo size 20244
undo change vector size 5452
SQL> insert into t_session select * from dba_objects;
已创建50338行。
SQL> select * from v_measure_redo_undo_size;
NAME VALUE
---------------------------------------------------------------- ----------
redo size 293836
undo change vector size 185864
SQL> select (185864-5452)/1024/1024 undo,(293836-20244)/1024/1024 redo from dual;
UNDO REDO
-------------- ----------
.172054291 .260917664
SQL> select * from v_measure_redo_undo_size;
NAME VALUE
---------------------------------------------------------------- ----------
redo size