Re: oracle on sun solaris

From: Bob Jones <email_at_me.not>
Date: Sat, 17 Jun 2006 00:30:16 GMT
Message-ID: <s2Ikg.65219$4L1.3772@newssvr11.news.prodigy.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1150473119.811423_at_bubbleator.drizzle.com...

> Bob Jones wrote:
>> "hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message 
>> news:1150374556.612939.226000_at_u72g2000cwu.googlegroups.com...
>>> 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.
>>>
>>
>> The bigger picture is "Do everything in Oracle". Pretty soon Oracle will 
>> have its own OS, that will make them potentially the next MS.
>
> When Oracle starts using license keys on its software I'll start
> worrying about it.
> -- 

License keys are not what make MS MS. Received on Fri Jun 16 2006 - 19:30:16 CDT