Re: redo log placement question

From: Svend Jensen <svend.jensen_at_it.dk>
Date: Wed, 15 Jan 2003 20:56:05 +0100
Message-ID: <3E25BCD5.8000706@it.dk>

Even OLAP must load data now and then to be updated, or am I wrong? Data load generate redo.

Redologs are continuous files being written to, in oltp it is mostly very often and very small writes. DW and OLAP is typicaly bigger writes occuring less often.

But it is easy to move (=> create new redolog file, remove old one), so I suggest you do a little test on your system. Gives best advice. Run a significant test with redolog on raid5, move redolog to raid1 and retest.
Select best fit.

/Svend

orasybase wrote:
> I understand the reasons most documents suggest not putting redo on
> raid-5 array. But my situation is limited to either on raid-5 with
> multiple controllers or on raid-1 with single controller. Raid-5
> hosts only database files, Raid-1 hosts OS and Oracle software. What
> will be the better option in this case? The operations are mostly
> OLAP.
>
> Any comments and suggestions are appreciated.
Received on Wed Jan 15 2003 - 13:56:05 CST