Could you suggest a good book for SQL tuning?

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Could you suggest a good book for SQL tuning?

Postby dariyoosh » Thu Oct 11, 2012 10:16 am

Hello Tim,


I would like to ask you some advice about how to learn SQL tuning. It has been a while since I have been reading the online oracle documentation : "Oracle® Database Performance Tuning Guide 11g Release 2 (11.2)" and I've learnt several concepts. Yet, I really believe that regarding my current beginner level, the documentation is too advanced for me. I'm totally beginner in the field of tuning and performance. I'm not DBA for now, and I work with oracle rather as a SQL-PL/SQL developer, so the priority for me at the present is to master SQL and PL/SQL tunning (joins, execution plans, etc.). Of course once I become familiar with the basics I'd be glad to go further. So what I'm looking for is a really beginner friendly and up to date book.


I did the same while I wanted to learn PL/SQL, I took Steven Feuerstein's book which seemed to me more suitable for a totally beginner. Once I became more familiar with the stuff I started reading oracle online PL/SQL documentation which was then much more useful and comprehensible thanks to the background with the Steven's book.

So I try to proceed in the same way for learning oracle tuning (most importantly starting by SQL tuning).

Could you kindly give me some guidelines, Tim? (books, tutorials, etc.)

Thanks in advance,

Kind Regards,

Dariyoosh
User avatar
dariyoosh
Member
 
Posts: 24
Joined: Tue Aug 11, 2009 11:18 am

Re: Could you suggest a good book for SQL tuning?

Postby Tim... » Thu Oct 11, 2012 1:26 pm

Hi.

I think Troubleshooting Oracle Performance, by Christian Antognini is an awesome book.

He considers himself a performance guy, not a DBA, so most of the book is focused on application tuning, rather than instance tuning.

If does go into quite a lot of detail, but the writing style is very accessible.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Could you suggest a good book for SQL tuning?

Postby dariyoosh » Fri Oct 12, 2012 10:13 am

Dear Tim,


Thank you very much for your advice. I've just checked on amazon.com and I saw that the book
is available in stock, so I think I'm going to purchase this one.

It seems to me that the book has been printed two times, once at June 2008 and last time at
December 2011 (still the 1st Edition), so it should be up to date.

So I'm going to read this and I will let you know if I progress :mrgreen: :mrgreen: :mrgreen:

Once again, thank you very much for your kindness and your help


Kind regards,
Dariyoosh
User avatar
dariyoosh
Member
 
Posts: 24
Joined: Tue Aug 11, 2009 11:18 am

Re: Could you suggest a good book for SQL tuning?

Postby Tim... » Fri Oct 12, 2012 10:50 am

Hi.

Much of the advice in it is appropriate to all versions of the database anyway.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17951
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 2 guests

cron