SQL> set autot on stat;
SQL> insert into t values(2,'b');1 row created.
Statistics
----------------------------------------------------------
0 recursive calls
5 db block gets
1 consistent gets
0 physical reads
0 redo size
914 bytes sent via SQL*Net to client
942 bytes received via SQL*Net from client
6 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
1 rows processed请大虾们帮忙看一下,为什么产生的redo size 为0? 按照我的理解,增、删、改都要产生redo信息的啊!
可以这么查
select b.value from v$statname a, v$mystat b
where a.statistic# = b.statistic# and a.name = 'redo size';insert前后各查一次,取差值。
这个set autot on stat,数据来源是哪里?