Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.10 - Release Notes

Log Buffer Space Wait Alarm

The Log Buffer Space Wait alarm occurs if the amount of time spent waiting for space in the redo log buffer exceeds a threshold. The redo buffer improves session performance by buffering redo log changes in memory. However, if the redo buffer is too small, or if the redo log writer is too slow, sessions may spend time waiting for space to be made available in the redo buffer.

Increasing the size of the initialization parameter LOG_BUFFER can help. However, if the real problem is the speed of the redo log writer process, then consider the recommendations in Improve Redo Log Writer Performance.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation