| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Useful Oracle books
Many thanks Mlladen. That answers my question accurately. I will do likewise. BTW, I don't know what Farenheit 451 is. Will Google for it when I have time.
Allan,
I see your point. Every book gives an idea, which needs to be
experimented with in design phase and accepted/rejected based on
the results. There is so much useful information so easily
accessible (this list, for eg.) that one might get into the habit
of being spoon-fed for every little thing. The unsure feeling that
I have even after reading much of useful material is probably
because of lack of testing it myself. BTW, you had me day-dreaming
there. A strong cup of coffee saved me from getting fired. :)
Ryan, You have summarized the nature of Harrison's book accurately. Thanks for your opinion.
Regards,
Charu.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala
Sent: 28 May 2004 19:34
To: oracle-l_at_freelists.org
Subject: Re: RE: Useful Oracle books
On 05/28/2004 09:47:33 AM, Charu Joshi wrote:
>
Throw away Guy Harrison's book? Haven't you seen Fahrenheit 451
(not to be confused
with the Fahrenheit 911)? Both books are good and it's hard to
tell which one is
better, because they're written using different perspective. Dan's
book basically
tells you how to tune any join and doesn't venture too deep in
oracle specifics.
The point at which the two books are closest is when Dan explains
how to turn
a non-correlated subquery into a correlated one, to delay
execution of the subquery.
Dan is using graph theory to develop something that can be
considered a mathematical
theory of tuning joins (nodes with attributes, uni-directional
graphs and similar
stuff), while Guy Harrison gets down with an arsenal of oracle
specific things
and practices. Harrison's book is a bit long-toothed now because
it was written
for Oracle 8i and not Oracle 10g, but it is still relevant. It
also discusses how
to organize tablespaces, using direct I/O, raw devices and alike.
Dan didn't delve
into those details, he confined his research on the SQL level and
did a comparative
study of Oracle, DB2 and the database whose name I will not utter
here. Both books
are very good, Dan's is a little bit newer, but both books are
worth reading. If I
were you, I'd start with Guy Harrison's work to give you broad
details about Oracle
and then venture into Dan's book and see it form the mathematical
side. You may
also want to throw "Optimizing Oracle Performance" by C. Millsap
("C" standing
for "Cary", not for "Carry" or "Carrie". Unce upon a time, there
was a lady named
Carry Nation, and I'm not sure that Mogens or me would get along
with her. She was
the foremost crusader against some mighty fine beverages and has
contributed signficantly
to the constitutonal amendment that is known as "prohibition")
which gives you yet
another perspective on tuning. Don't feed that book to the flames,
either. It's SQL
tuning from yet another perspective.
-- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************* Disclaimer: This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri May 28 2004 - 09:32:10 CDT
 |
 |