Re: Oracle Myths

"Alan" <alanshein_at_erols.com> wrote in message news:ac1304$m75sv$1_at_ID-114862.news.dfncis.de...
> Well, I read through the archived messages, and discovered that either
half
> the Oracle experts don't know what they're talking about, or that half the
> Oracle experts know what they are talking about. The other half aren't
> talking. Anyway, I posted the question to Metalink, so we'll see what the
> consensus of the Oracle cube-dwellers is. Too bad there's no SQL standard
> related to this problem- if there was we could count on a definitive
answer,
> or at least one from Joe Celko.

Of course you can ignore this if I don't know what I am talking about! but Jonathan's book has the following lesson drawn from the Cautionary Tale which I consider to be some of the best advice to be found in any Oracle book anywhere.

1. You only know what you have discovered so far
2. What worked last time might not work next time
3. Different isn't necessarily wrong.

At least some of the rules I've referred to above as Myths have or had some basis in fact. Others of them notably the buffer cache myth have some merit but don't actually say what they are widely considered to say. I'm considering working some of these (say the top 5) into a presentation, but it will be interesting to see what comes out of your tar and Mark's offer to raise with the devs. (plus I'm hoping to have 9i2 to play with soon bandwidth permitting)

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************