Re: oracle on sun solaris

DA Morgan wrote:
> hopehope_123 wrote:
> > Hi ,
> >
> > We are about to move our current datawarehouse system from redhat
> > linux to a sun solaris box. ( 6 dual core cpus, 2 hba , emc disk
> > array , raid 10 , 24GB. RAM)
> >
> > The db size is about 2tb.
> >
> > Since this is a datawarehouse system , random sequential io is my main
> > concern , we also use parallel query heavily.
> >
> > I have some questions on my mind:
> >
> > 1. What file system to choose? UFS , Veritas or raw device?
> >
> > 2. If i choose ufs or veritas , should i use direct_io or not? Since
> > parallel query bypasses the sga , and directIO bypasses the page
> > cache , using buffered io is better .
> >
> > 3. How can i coose the strip size of the raid?
> >
> > 4. In order to maximize the sequential io performance , i am thinking
> > of setting db_file_multiblock_read_count to 1MB. ( Which provides 1MB.
> > read on each disk read) , along with the unix kernel parameters
> > maxcontig (for ufs) etc. How can i balance this number with the strip
> > size? Is 1MB. maximum?
> >
> >
> > I will be appreciated if you can comment , advise.
> >
> >
> > Kind Regards,
> > hope
>
> I'd recommend RAW managed with ASM.
>
> But I'd also temper that recommendation, or any recommendation, by
> recommending that you build a test lab and run a test series before
> making the decision.
>
> Would recommend you avoid third-party products that will inevitably
> lead to higher costs, training issues, and vendor finger-pointing
> exercises.

That sounds like a recommendation from someone will little practical experience with veritas on solaris? That set of products is not exactly uncommon in the oracle world.

We realize the current mantra from oracle is ASM ... nice job repeating it. Received on Thu Jun 15 2006 - 07:29:16 CDT