Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's Myth: keep tables and indexes in separate tablespaces
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