Re: type of striping

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 08 Dec 2004 13:59:49 +0100
Message-ID: <cp6ts2$k36$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

You might be right, but to be Howardian about this, you should not think; the OP should clarify the question and make clear what the purpose of this striping would be.

All else would be guessing (but did, in fact, result in a nice thread), wouldn't it?

-- 
Regards,
Frank van Bortel

Received on Wed Dec 08 2004 - 06:59:49 CST