测试如下：
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 9 11:21:05 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
首先查看一下当前日值的生成量：
SQL> select a.name,b.value from v$mystat b, v$statname a where a.statistic#=b.statistic# and a.name like '%redo size%';
NAME value
---------------------------------------- ----------
redo size 0
创建一个表：
IXDBA.NET社区论坛
SQL> create table exitgogo12 as select * from all_objects;
表已创建。
再看redo生成量：
SQL> select a.name,b.value
from v$mystat b,v$statname a
where a.statistic#=b.statistic# and a.name like '%redo size%';
NAME value
---------------------------------------------- ----------
redo size 5644812
执行insert语句，查看日值的生成量：
SQL> insert into exitgogo12 select * from exitgogo12;
已创建49314行。
SQL> select a.name,b.value from v$mystat b,v$statname a where a.statistic#=b.statistic# and a.name like '%redo size%';
NAME value
----------------------------------------- ----------
redo size 11172340
SQL> select 11172340-5644812 from dual;
11172340-5644812
----------------
5527528
这是insert语句日志的生成量。
查看日值的生成量还可以用autotrace跟踪，具体操作如下：
SQL> set autotrace trace stat
SQL> insert into exitgogo12 select * from exitgogo12;
已创建98628行。
统计信息
----------------------------------------------------------
642 recursive calls
7727 db block gets
4756 consistent gets
9 physical reads
11060672 redo size
673 bytes sent via SQL*Net to client
584 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
8 sorts (memory)
0 sorts (disk)
98628 rows processed
SQL>
SQL> select name,value from v$sysstat where name='redo size';
统计信息
----------------------------------------------------------
17 recursive calls
0 db block gets
7 consistent gets
0 physical reads
0 redo size
472 bytes sent via SQL*Net to client
385 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> quit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 9 11:39:09 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
看一下全局数据库的redo生成量，可以通过v$sysstat视图看到：
SQL> select name,value from v$sysstat where name='redo size';
NAME value
-------------------------------------- -----------
redo size 23128768
从v$sysstat视图中看到的是自数据库实例启动以来的累计日志生成量。
