Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, vishnudas.

Asked: February 18, 2019 - 6:21 am UTC

Last updated: February 20, 2019 - 11:51 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

Hi Team,
i am kinda new to SQL performance tuning, So i need you guys to suggest me some helpful hand books
(with test cases) which will suit for me.
I have googled for it but don't know which one should i prefer as a newbie.
So please share your ideas on this... :)

and Connor said...

"Troubleshooting Oracle Performance, 2nd Edition" - Christian Antognini

is best book out there in my opinion. It goes through a suite of important fundamentals, and then moves onto using those fundamentals to methodically approach any SQL tuning problem.

I strongly recommend it.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

vishnudas, February 20, 2019 - 6:30 am UTC

Thank you for your suggestion..
Chris Saxon
February 20, 2019 - 11:51 am UTC

You're welcome

Others books

David D., March 01, 2019 - 9:35 am UTC


Yes, the book of Christian is very very good.

You can read also
1) "Oracle Database 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press)" by Richard Niemiec but be careful, 1250 pages :-)

2) "Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach (Expert's Voice in Oracle)" by Sam Alapati (Author), Darl Kuhn.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.