RE: books on query tuning

  • From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
  • To: "usn@xxxxxxxxx" <usn@xxxxxxxxx>, "cicciuxdba@xxxxxxxxx" <cicciuxdba@xxxxxxxxx>
  • Date: Mon, 7 Jun 2010 10:11:21 -0500

That book is tremendous if you want to understand the various algorithms for 
things such as redo/undo, cache management, etc but I don't think it is all 
that useful for purely sql tuning.

I don't think there is a single source that will give you the background you 
are looking for.  I've learned something new from every source I've read.  
Nothing can really replace experience in working out actual sql problems though.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Martin Klier
Sent: Monday, June 07, 2010 9:30 AM
To: cicciuxdba@xxxxxxxxx
Cc: oracle-l-freelists
Subject: Re: books on query tuning

I think the new Performance Firefighting book written by Craig
Shallahamer should be quite good. Did not buy it for myself yet, don't
even know if it's already out. But I like his writing, so I will buy it,
it's the next on my list.


Guillermo Alan Bort schrieb:
> Listers,
>
>   I've been working as a physical DBA for a long time and have developed
> my instance tuning skills rather well. However, I want to direct my
> career to a more comprehensive type of DBA and was wondering if there
> were any books on query tuning, both oracle specific and general 'good
> practices' you could recommend.
>
> Thank you very much.
> Alan.-

--
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
//www.freelists.org/webpage/oracle-l



CONFIDENTIALITY NOTICE:
        This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is privileged, 
confidential and exempt from disclosure under applicable law.  If the reader of 
this message is not the intended recipient or the employee or agent responsible 
for delivering this message to the intended recipient, you are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited.  If you have received this communication in error, please 
notify us immediately by email reply.


--
//www.freelists.org/webpage/oracle-l


Other related posts: