Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces

Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 10 Oct 2003 17:55:15 +1000
Message-Id: <3f866670$0$29372$afc38c87@news.optusnet.com.au>


Mark Townsend wrote:

> Howard J. Rogers wrote:
>> Jack wrote:
>>
>>
>>>Look:
>>>http://otn.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
>>>
>>>You might have a look at Juan Loaiza's article "Optimal Storage
>>>Configuration Made Easy" http://technet.oracle.com/deploy/performance/
>>>for a
>>>different approach to the problem. Since this is on technet, it appears
>>>to be Oracle's latest recommendation.
>
>> Sorry Jack: you're wrong on this, though I suppose it depends on what you
>> mean by 'recommendation'.
>
> I don't believe that Jack is wrong.

It's not a matter of belief. If the course notes say it in black and white, then he's wrong.

>In fact, if the courses ARE teaching
> it differently,

No, they've been teaching it in exactly the same way since at least version 8.0.

>then I think the course needs to be urgently updated -
> can anybody send me a reference number, and I'll follow up on it.

They just *have* been updated. Check out 9i Performance Tuning. They've just released version 2.1 of that document, and it contains the 'separate tables from indexes' "recommendation" in Chapter 3. I taught it just last week, and my notes were version 2.0, and the students had version 2.1... that's how recent the update of the material was... I didn't actually get told a new revision had been issued. Fortunately, the changes were minor (and this wasn't one of them).

I can't give you the course code, I'm afraid, because I haven't actually cleared my desk out yet, so the manuals are still sitting in the office.

But I can promise you that Fundamentals I is still "recommending" the same thing, too.

I only know it because every time I teach it I have to spend 15 minutes explaining why the course notes are wrong, usually to a bunch of initially-sceptical faces. And it's been that way for years, so I doubt anything will change in a hurry.

If you care to wait until early next week, I can have the precise course codes and page numbers for you (unless Richard wants to jump in beforehand).

>
> Note that ASM (Automated Storage Management) in Oracle Database 10g
> implements the SAME methodology as the preferred (and only supported)
> best practice.

Oh dear. SAME isn't a magic bullet, either. Frying pan and fire time, I suppose. Still it's better than nothing.

Regards
HJR

-- 
--------------------------------------------
See my brand new website, soon to be full of 
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------
Received on Fri Oct 10 2003 - 02:55:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US