During update activity, redo logs are written to in a continous and
sequential manner, adn are not read under normal circumstances. Because of
this, Raid5 would be the worst choice for performnce.
RAID0 arrays will yield the bst performance for continous sequential writes.
Even if place on RAID1 arrays, the redo logs should still be mirrored at the
Oracle level. If the log writer process determines that it does not know
whether the contents of a particular redo log are valid, it will mark that
redo log as "STALE" in the v$log table. If this redo log is the only copy,
then it cannot be archvied, and will cause a database halt.
jennetta <jennetta_at_hotmail.com> wrote in message
news:850tb2$a9i$1_at_news.duke.edu...
> Should Redo Log Files be on RAID5??? Is there a negative impact on
> performance?
> How about the database files? Oracle Server files? Operating system files?
>
> Any suggestions/experiences regarding performance will be appreciated.
>
>
Received on Wed Jan 05 2000 - 23:50:32 CST
