验证日志增长

---- 1 windowconn scott/tiger;select * from tab;drop table t1;create table t1 as emp;insert  into  t1 select * from t1;/////commit;-- 2.windowsqlplus / as sysdba;conn / as sysdba;SELECT * from v$sysstat where class=2;select value from v$sysstat where STATISTIC#=178;  -- 178 是上条语句查出的 redo size 对应的 statistic# 号SQL> SELECT value from v$sysstat where STATISTIC#=178;     VALUE----------   3776244   -- 1.windowupdate t1 set sal=sal+1 where empno=7900;commit;-- 2.windowSELECT value from v$sysstat where STATISTIC#=178;  -- 注意比刚才大了； 约几M ，这里假定 3Malter tablespace users begin backup;  -- 冻结表空间；-- 1.windowupdate t1 set sal=sal+1 where empno=7900;commit;-- 2.windowSELECT value from v$sysstat where STATISTIC#=178;  -- 注意第一次update大好； 增长一倍alter tablespace users end backup;