RE: RE: Useful Oracle books
- From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 May 2004 20:16:07 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mladen Gogala
Sent: 28 May 2004 19:34
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RE: Useful Oracle books
On 05/28/2004 09:47:33 AM, Charu Joshi wrote:
>
> I purchased Harrison's book about 3 months before I heard of Dan
> Tow's book. Now I am a bit afraid that I might get
wrong/outdated
> facts. Can anybody tell what parts of the book are still
relevant
> and what parts are best avoided? Or should I throw it away and
go
> for Dan's book?
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
