Re: separate data/inidex

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). 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.