Re: UFS vs Raw

From: <dougcoan_at_my-deja.com>
Date: Thu, 19 Aug 1999 14:59:11 GMT
Message-ID: <7ph63o$v3n$1@nnrp1.deja.com>

In article <7pf8ns$ju2$1_at_nnrp1.deja.com>, jeperkins4_at_my-deja.com wrote:
> Does anyone have a definitive answer for filesystem type for Oracle on
> Solaris 2.7?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

I'de like to say I have vast experience with Solaris, but I don't. I think I can however give you some info to help you make your decision. Raw devices are faster, but not as much as you would think. 3% to 15%. NT would benefit the least from RAW while AIX the most.

Raw partitions are a real real real pain to work with. If you have a VLDB (ie > 200GB) you might consider them. Other than that, its's probably more trouble than it's worth.

DO NOT USE RAID 5. USE RAID 0+1 for performance.

There are my 2 cents.

Doug Coan
Senior Client Server Integrator
AEGON USA
dcoan_at_Aegonusa.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 09:59:11 CDT