Oracle’s redo log is a frequent source of intensive IO and, by design, Oracle sessions will normally wait for
redo log IO to complete. However, the nature of redo log IO operations is essentially optimal for magnetic
disk but least suitable for solid state disk. Redo log IO consists almost entirely of sequential write operations,
which are the worst case for solid state disk and the best case for magnetic spinning disk. Placing
redo logs on solid state disk is generally not recommended
When IO bottlenecks are limited to specific segments (tables, partitions, or indexes) then relocating those
segments to solid state disk will almost always be effective in optimizing IO to those segments, regardless of
the type of IO to which the segments are subjected
from guy harrison blog : http://guyharrison.squarespace.com/blog/2011/10/27/using-flash-disk-for-redo-on-exadata.html
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a
Single Cloud VM
-
Hands-on technical analysis of a novel data platform for high-performance
block I/O in the cloud, tested by Tanel Poder, a database consultant and a
long-t...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu