Re: separate data/inidex

In article <B8EA33EC.1EA55%markbtownsend_at_attbi.com>, Mark says...
>
>
>Cheers - you will of course note that the wording has changed between the
>versions. This change is for a reason - to remove the myth about indexes and
>data needing to be seperated.
>
>This myth has been around for a long time - and unfortunately was actually
>started by an Oracle consultant (who will remain nameless).

And it wasn't me!

So it does
>permeate some of the earlier docs (which is why I asked you to point it out
>for me), but is slowly and steadfastly being exposed for the myth it is.
>
>For the (currently) definitive document on data/disk placement, see the
>white paper on SAME (Stripe And Mirror Everything) at
>http://otn.oracle.com/deploy/availability/pdf/oow2000_same.pdf
>
>This is a good, generic replacement guideline that suits most workloads and
>also drives HA. It IS, however, a generic set of guidelines, and should not
>be treated as dogma. It is also subject to change as Oracle's IO profile,
>and the underlying capabilities of disk storage, evolve.
>
>
>in article 3CC43663.EC885A8A_at_exesolutions.com, Daniel Morgan at
>damorgan_at_exesolutions.com wrote on 4/22/02 9:12 AM:
>
>> Just did. But here are two of them again:
>>
>> 8.1.7
>>http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a7
>> 6956/dfiles.htm#423
>>
>> 9i
>>http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a9
>> 0117/dfiles.htm#7384
>>
>> If you want the rest go to technet and type in the following text in the
>> "Search
>> for:" box: "Place Datafiles Appropriately". Same advice goes for tahiti. It's
>> everywhere it's everywhere.
>>
>> As Pogo said: "We have met the enemy and it is us."
>>
>> Daniel Morgan
>>
>>
>>
>> Mark Townsend wrote:
>>
>>> in article 3CC30C98.4977F6F5_at_exesolutions.com, Daniel A. Morgan at
>>> damorgan_at_exesolutions.com wrote on 4/21/02 12:01 PM:
>>>
>>>>So who at Oracle is charged with correcting all of the information that goes
>>>> out under
>>>> its name. Not just at Oracle Press, but at technet, tahiti, etc.
>>>
>>> The relevant people for technet and tahiti are reading the newsgroup. If you
>>> see anything specific, by all means point it out.
>>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Apr 25 2002 - 00:24:57 CDT