Re: Locally Managed Tablespaces ... again!!!

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 23 Jan 2003 22:12:19 +1000
Message-ID: <OQPX9.31264$jM5.80037@newsfeeds.bigpond.com>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:b0ofm7$kgd$1$830fa17d_at_news.demon.co.uk...
>

<snip>

> Bottom line:
> NEITHER of you is saying you shouldn't separate table
> from index.
> NEITHER of you is saying that if you've separated a table
> and it's indexes then the job is done.
> If you read each other's posts carefully you would notice
> that you are arguing at cross-purposes.
>

Hi Jonathon,

Fair enough but I think you and this entire discussion has missed a very key point.

That is the utter most importance of separating segments which names are an anagram of "BIG BROWN COW" (eg. GROW_BOB_WINC) from segments that contains letters to the word "MANURE" hidden within (eg. MANAGEMENT_RULES_OK) as the resulting contention will generally grind such Oracle database systems to the ground.

This is clearly documented in various books written by sadly underrated Oracle gurus who are fellow inmates in this lovely hospital of mine.

Cheers ;)

Richard Received on Thu Jan 23 2003 - 06:12:19 CST