Re: type of striping

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 08 Dec 2004 14:06:24 +0100
Message-ID: <cp6u8c$o9p$1@news3.zwoll1.ov.home.nl>

Chuck wrote:
> Frank van Bortel wrote:
>

>> yls177 wrote:
>>
>>> Hi, i understand that there are different types of striping for raid 0.
>>>
>>> 1) OS/Hardware striping
>>> 2) manual striping
>>>
>>> And the general consenus is that OS/Hardware striping is better than 
>>> manual.
>>>
>>> Please advise
>>
>>
>>
>> Advise what?
>> Against the general consensus? Which would probably be hardware
>> over software, btw.
>>
>> How would you stripe manually?!? Get your sleeves rolled up,
>> put on your high voltage protection gloves, and jump into the
>> computer case?
>>

>
> By manual striping, I think he meant the old practice of manually
> pre-allocating extents to specific datafiles. I don't think anyone does
> this anymore. Back in v7 Oracle used to allocate extents in a different
> way than it does today. If you had multiple datafiles in a tablespace,
> it would fill the first datafile, then the second, etc. Now it
> distributes the extents evenly across all datafiles in the tablespace,
> effectively doing automatically what DBA's used to have to do manually.
> You can probably still find references to manual striping in the old v7
> manuals if they are still online anywhere.
> --
> Chuck

And I, too, should have been more precise about "think" :-) Of course you can think - you should not try to guess what someone meant with a particular question. Maybe it was just a question like: hey, I've got this bunch of hardware being delivered soon, what can I do regarding striping?
Use hardware striping, use software (O/S, presumably?) striping, or do it manually (which still is unclear: the alternative you mention would be better that s/w striping, unless you regard that is s/w striping (by Oracle), too)

Oh, well - still stabbing in the dark about the OP's thoughts...

-- 
Regards,
Frank van Bortel

Received on Wed Dec 08 2004 - 07:06:24 CST