自己去做一做,比告诉你结论强的多
SQL> select name,value from v$sysstat where name like '%redo%';
NAME
VALUE
---------------------------------------------------------------- ----------
redo synch writes
1
redo synch time
0
redo entries
60
redo size
13364
redo buffer allocation retries
0
redo wastage
5484
redo writer latching time
0
redo writes
22
redo blocks written
38
redo write time
0
redo log space requests
0
NAME
VALUE
---------------------------------------------------------------- ----------
redo log space wait time
0
redo log switch interrupts
0
redo ordering marks
0
14 rows selected.
SQL>
请教biti_rainy:
我做了一下实验 1。 alter table client nologging
2.select name, value from v$sysstat
where name like 'redo entries';
insert /*+append*/ into client
nologging
select * from bk_client;
select name, value from v$sysstat
where name like 'redo entries';
结果是redo entries299 。 已创建5行。 redo entries 303。
为什么会有redo entries 产生呢?