27th October 2009
in
Redo Logs
Ce petit script permet de savoir si nos redo log switchent trop souvent ou pas assez.
Si ils switchent trop souvent alors cela peut engendrer des problèmes d’I/O, engendrer du redo-log contention.
Si ils ne switchent [...]
Tags: Mesure redo-log
No Comments
28th September 2009
in
Redo Logs
One of the best ways I have found to resize or recreate online redo log files and keep the current sequence is to perform it online. In this example, we will resize all online redo logs from 100MB to 250MB while the [...]
Tags: Recreating Online Redo Log, Redo Log, Resizing
No Comments