10.2.0.5 on windows 2008
从undo change vector size看得出来无论是logging或者是nologging 都没有变,也就是设定logging或者是nologging对undo 都没有影响;
使用如下语句
select a.NAME, b.VALUE
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and (a.NAME like '%undo change vector size%' or
a.NAME like '%redo size%' or a.NAME like '%direct%' or a.NAME like '%redo entries%');
create table test_direct as select * from g_sn_travel where 1=2;
alter tabel sajet.test_direct nologging;
insert /*+ APPEND */ into test_direct select * from g_sn_travel where rownum <100;
SQL> select a.NAME, b.VALUE
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and (a.NAME like '%undo change vector size%' or
5 a.NAME like '%redo size%' or a.NAME like '%direct%' or a.NAME like '%redo entries%');
NAME VALUE
---------------------------------------------------------------- ----------
db block gets direct 3
consistent gets direct 0
physical reads direct 0
physical writes direct 3
physical reads direct (lob) 0
physical reads direct temporary tablespace 0
physical writes direct (lob) 0
physical writes direct temporary tablespace 0
redo entries 3
redo size 468
undo change vector size 76
table scans (direct read) 0
index fast full scans (direct read) 0
13 rows selected
SQL> rollback;
alter table sajet.test_direct logging;
insert /*+ APPEND */ into test_direct select * from g_sn_travel where rownum <100;
SQL> select a.NAME, b.VALUE
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and (a.NAME like '%undo change vector size%' or
5 a.NAME like '%redo size%' or a.NAME like '%direct%' or a.NAME like '%redo entries%');
NAME VALUE
---------------------------------------------------------------- ----------
db block gets direct 3
consistent gets direct 0
physical reads direct 0
physical writes direct 3
physical reads direct (lob) 0
physical reads direct temporary tablespace 0
physical writes direct (lob) 0
physical writes direct temporary tablespace 0
redo entries 5
redo size 25100
undo change vector size 76
table scans (direct read) 0
index fast full scans (direct read) 0
13 rows selected
SQL> rollback;
|