Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Oracle Performance Tuning 101

4.4 out of 5 stars 30 customer reviews
ISBN-13: 978-0072131451
ISBN-10: 0072131454
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Condition: Used: Very Good
Comment: .
Access codes and supplements are not guaranteed with used items.
23 Used from $0.38
More Buying Choices
16 New from $17.75 23 Used from $0.38
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Save Up to 90% on Textbooks Textbooks

Editorial Reviews

From the Back Cover

Learn to optimize and fine-tune your Oracle system's overall performance

Implement tuning solutions using the proven methodology found inside "Oracle Performance Tuning 101 gives you step-by-step practical advice for removing bottlenecks, minimizing downtime, and increasing overall system performance. You'll also get tips for identifying Oracle's current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistics, and much more. Written in a clear and engaging style, this book explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork.Understand the key components of a tuning methodology Set performance objectives, establish goals, and cease efforts when goals are met Learn how to generate well-written SQL commands--and know how to recognize poorly written SQL Tune and manage various components of the Oracle Instance Use meaningful Oracle initialization parameter settings Implement proactive management of space in the Oracle database Understand I/O tuning with extensive coverage on implementing RAID on Oracle Get details on operating system tuning for Solaris, HP-UX, AIX, and Windows NT

Every chapter includes one or more myths and folklores about the topic, examples, and an "In a Nutshell" section--all geared to reinforce the knowledge you've acquired.

About the Author

Gaja Krishna Vaidyanatha (Coppell, TX) has over eight years of experience as an Oracle DBA at a variety of companies such as Quest Software, Brio Technology and Andersen Consulting LLP. He was also a Principal Instructor at Oracle for over three years--developing portions of the Oracle8 DBA curriculum and delivering tuning consulting and training for many Fortune 500 companies. Gaja is a member of IOUG-A and was a VIP presenter at IOUG-A Live 2000.

John A. Kostelac, Jr. (Houston, TX) has been applying his expertise as an Oracle DBA for close to 10 years. John is Consulting Senior Principal Instructor for Oracle Corporation in Dallas.

Kirtikumar Deshpande currently works as a Senior Principal Consultant in the Advanced Technology Solutions group at Oracle Corporation. He has more than 28 years of experience in the Information Technology field, including more than 15 years with Oracle. He co-authored "Oracle Performance Tuning 101" and "Oracle Wait Interface: A Practical Guide to Performance Tuning & Diagnostics" published by Oracle Press. For the latter, he and his co-authors were selected "Oracle Magazine s" Editors Choice Award Author of The Year in 2005. He is a frequent speaker at various Oracle User Group conferences worldwide.

John A. Kostelac, Jr. is an Oracle database administration consultant and operates an information technology consulting firm. He specializes in performance and recovery issues for Oracle databases. Additionally, he is experienced in every phase of modeling, design and implementation of Oracle databases for a variety of applications. John can be reached by e-mail at john@winningstaff.com


Product Details

  • Series: Oracle (McGraw-Hill)
  • Paperback: 404 pages
  • Publisher: McGraw-Hill Osborne Media (May 29, 2001)
  • Language: English
  • ISBN-10: 0072131454
  • ISBN-13: 978-0072131451
  • Product Dimensions: 7.5 x 0.9 x 9.2 inches
  • Shipping Weight: 1.8 pounds
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (30 customer reviews)
  • Amazon Best Sellers Rank: #2,904,454 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
Two stars may be a little harsh; I'm sure the author is very knowledgable. However, there is a difference between making a lot of true statements and imparting knowledge to someone else (explaining).
First, be warned the book only is relevant to Oracle 7 and 8i. Oracle 9 tuning is not addressed. A lot has changed in Oracle 9 because of the automatic tuning features, so I feel this book is out of date and it is shameful that book sellers disguise this fact.
There is a lot wrong with this book from the standpoint of someone who needs to tune Oracle. If you are a full time DBA and spend a lot of time studying Oracle and Oracle is your life, then perhaps this is a useful book for your collection. In that respect, the "101" in the title is perhaps accurate - it opens the subjects that you will need to dig a lot deeper into in order to really get something useful done. However, if you need a guide to tuning your Oracle database, you probably will be lost and frustrated using this book.
The author in opening chapters lays out a tuning methodology which is basically "measure performance; locate bottleneck; tune appropriate component". Then he pretty much abandons that methodology and stuffs the book with brief descriptions of how Oracle does this and that, some related parameters, and some very general advice to wrap it up. But unless you take it much further yourself with other references and deep study, you will be hard pressed to know how to fix anything.
Many Oracle books I have come across suffer from the problem of being either 3 times too long or 1/3 as long as necessary.
Read more ›
Comment 15 of 19 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
An excellent book every Oracle shop should have. It is hard to find a book that at the same time is so rich in technical details, so easy to read, with so many cool and illustrative analogies (e.g. pctfree/pctused comparison to a restaurant), and with a fine human touch. The book has five parts plus Appendices. Part One established the groundwork for the remaining of the book. This is the first book that bases its approach and treats in full Oracle wait event tuning, as opposed to long traditional ratio-based tuning. Part Two deals with Application tuning: optimizers, statistics, access paths. Part Three is devoted to Instance and Database tuning: shared pool, buffer cache, redo log buffer tuning, as well as physical layout tuning: optimal block selection, avoiding fragmentation, partitioning. Part Four is called Specialized Tuning where parallel query and contention tuning are analyzed. Finally Part Five is devoted to "Environment Tuning", i.e. tuning of the OS (few flavors of unix and NT are separately treated) and, as far as I know, the most detailed coverage of RAID in any oracle book. The book is very easy to read, written very clearly and with a lot of humor. Every chapter starts with a related "myth" - a common knowledge that is either false, or not completely true, and ends with an "In a Nutshell" recap of the chapter. The book itself ends with a recap chapter, which in short reviews the whole tuning methodology (yet the RAID tables might have been omitted from this recap). The book has short queries that are illustrating the text, which are not difficult to retype, so the lack of a CD with the code from the book is not a disadvantage. Talking of queries, few more here and there would not hurt.Read more ›
Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Oracle Performance Tuning 101 will change every
DBAs thinking about how to diagnose
and solve database performance problems in
a way which the DBA can understand what is really
going on behind the scenes. It is not about
black magic or hocus pocus Cache Hit Ratios
which do NOT explain the underlying behavior
of why the database is waiting and exactly
what is it waiting on. This Book helps you
understand how to find that wait information,
what it means, and some suggestions on how
to deal with it.
When I first read Chapter 2 of this book,
I remembered saying "WOW ... a new era is here
on how to track down bottlenecks in the Oracle
database, without scratching your head wondering why
the database wont go faster after we got
some hit ratio percentage back to 99%+".
As Gaja, Kirti and John have so eloquently
pointed out, tuning is mostly about finding what
is competing for the Oracle blocks. In the
end, this is causing the wait events and more
than likely all tracks lead back to expensive
logical I/O and underlying poorly written SQL.
For those that have been advocating spending tens
of thousands on new hardware or increasing the
shared pool ( which actually could cause adverse
behavior ) to fix performance issues, YOU need
to buy this book and read it. Then YOU need to
read it a second time as you would a college text.
Every Oracle DBA and every person who has
ever wrote a book on Oracle Performance Tuning,
should also read and adhere to the principles
of this book when attacking slowness in the
Read more ›
Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Want to discover more products? Check out this page to see more: oracle certification