hpuxrac wrote:
> hpuxrac wrote:
>> 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 .
>>>>
>
>>> 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.
>
> Mr. Morgan, what is your experience level with those products?
Since I didn't write the comment to which are responding I'll leave it
to the person that wrote that statement to reply to you.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 19 2006 - 11:40:54 CDT
