|
关于redo log buffer contention的两个问题?
A.当V$SESSION_WAIT 中的字段 SECONDS_IN_WAIT 如果大于0,那么表示 time was spent waiting for space
in the redo log buffer.
那么为了减小等待时间,两个方案:
1.增大redo log buffer
2.将redo log file 放置于faster disks上。
B.当查询V$SYSSTAT中的 Redo Buffer Allocation Retries 大于1% of the Redo Entries,process have had
to wait for space in the buffer. 应该要增加redo log buffer的大小,或improve the checkpointing
or archiving processes to minimize the number of waits.
为何A的解决方案是将redo log file 放置于faster disks上,而B的解决方案是improve the checkpointing or archiving processes to minimize the number of waits.
可以解释区别吗?为什么?
谢谢!
|
|