Re: NT Oracle - Raid 5 - Recommendations for 3GB db

I'd say go with it. And stress test it. RAID5 should be as good on reads as striped drives. If that's mostly what your db does, then you should be OK.

One thing I would think about is TEMP (you mention redo). If many of these reports aggregate and/or sort data (pretty typical) then you might want to move the TEMP tablespace(s) off from the RAID5 array...

Basically just set it up and monitor it, both at the Oracle level and the OS level. Be prepared to make changes if necessary.

MotoX.

chajec_at_my-dejanews.com wrote in message <6pni2a$ttr$1_at_nnrp1.dejanews.com>...
>I've read several posts here regarding Raid-5 on Windows NT for ORacle
>databases. It says pretty much that reads are OK, but writes are slower.
>
>What do you think about if I have a database of 3 GIG and 30 concurrent
>users on the database? Majority of work is query for report generation
>and such. What would you suggest or how would my performance be?
>I'm thinking about Raid-5 for my datafiles spread over 3- 4.5GB disks + 1
hot
>spare and my redo logs on another disk that is mirrored. My total number
of
>drives is 6 - 4.5GB drives. My database won't be growing much more than it
>already is.
>
>Let me know what you think.
>
>Chajec_at_my-dejanews.com
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 30 1998 - 02:25:16 CDT