Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle Performance Tuning 101 Paperback – May 29, 2001

ISBN-13: 978-0072131451 ISBN-10: 0072131454

27 New from $4.92 29 Used from $0.01 1 Collectible from $9.98
Amazon Price New from Used from
Paperback
"Please retry"
$4.92 $0.01
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

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: 9.3 x 7.5 x 0.9 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: #1,970,595 in Books (See Top 100 in Books)

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.


More About the Author

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

Customer Reviews

4.4 out of 5 stars
5 star
21
4 star
4
3 star
1
2 star
4
1 star
0
See all 30 customer reviews
What tool can you use for performance tuning.
Mark Twain
This is a must have book for Oracle DBAs and Oracle Developers responsible for database/server tuning.
M. Schmidt
The book is very easy to read, written very clearly and with a lot of humor.
Djordje Jankovic

Most Helpful Customer Reviews

15 of 19 people found the following review helpful By developer1 on December 29, 2003
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By Djordje Jankovic on December 13, 2001
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Michael C Johnson on January 27, 2003
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
system/database.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?