This guide provides Oracle DBAs with the know-how to tune and tweak Oracle databases to achieve optimal performance results, using real-world examples. There is information on bottlenecks, undocumented parameters and performance-enhancing tips useful to Oracle DBAs. It provides specific examples to build performance tuning skill sets. The tips and techniques have been compiled directly from Oracle User Groups around the world.
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more. |
Book Description
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
From the Author
Buy and Read this Book and you'll be Great at Tuning Oracle!
Whether you are a DBA or Developer, buy and read this whole book and you will learn what I have learned painfully in over a decade of tuning Oracle. This was VERY painful to write and I only wrote it so that YOU could feel that great feeling from making the impact that tuning brings. I repeat some topics in the book more than once so that each chapter can be read independently (hard to have the time to read it all at once). This is my gift back to you … make sure that you take advantage of it. Also, there is no CD ... I highly recommend the books PL/SQL Tips and Techniques by Joe Trezzo and Oracle8i Web Development by Bradley Brown. Also, an advanced tuning book on Latches is great by Steve Adams and on UNIX tuning by Ahmed Alomari.
Whether you are a DBA or Developer, buy and read this whole book and you will learn what I have learned painfully in over a decade of tuning Oracle. This was VERY painful to write and I only wrote it so that YOU could feel that great feeling from making the impact that tuning brings. I repeat some topics in the book more than once so that each chapter can be read independently (hard to have the time to read it all at once). This is my gift back to you … make sure that you take advantage of it. Also, there is no CD ... I highly recommend the books PL/SQL Tips and Techniques by Joe Trezzo and Oracle8i Web Development by Bradley Brown. Also, an advanced tuning book on Latches is great by Steve Adams and on UNIX tuning by Ahmed Alomari.
From the Back Cover
Expert Technical Knowledge at the Turn of a Page.
Tune and tailor your Oracle7 or Oracle8 system to perform at its peak using this one-of-a-kind reference, designed for every Oracle database administrator, programmer, and user.
In Oracle Performance Tuning Tips & Techniques, you'll find hundreds of real-world examples and insider secrets compiled from TUSC's standing-room only conference presentations and Oracle User Groups worldwide. From finding and fixing bottlenecks to enhancing performance using PL/SQL, this authoritative guide reveals proven methods for getting the most from your Oracle system throughout its lifecycle.
- Discover the Top 10 Tuning Tips used by industry experts to improve performance
- Maximize tuning with the most important basic, advanced, and undocumented INIT.ORA parameters for Oracle7 and Oracle8
- Use Explain Plan and Tkprof to uncover problem queries that, when corrected, result in peak performance
- Explore the new features in Oracle8 to gain peak performance by uncovering problem queries
- Refine your tuning skills by exploring the new features in Oracle8
- Take advantage of key V$ Views and X$ Tables to enhance performance
Developed through years of consulting expertise, Oracle Performance Tuning Tips & Techniques is packed with time-saving tuning gems designed to ensure top system performance.
Inside This Book
(Learn More)
First Sentence
Oracle is a symphony and you are the conductor, with an opportunity to create a world class performance. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Oracle is a symphony and you are the conductor, with an opportunity to create a world class performance. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
By A Customer
Format:Paperback
This is a great book for ORACLE tuners from instance to application level - it has a lot of ideas with examples in plain english - explaining the dynamics and the benefits you gain.
It's one of those rare books written by somebody who's obviously used the product in a 'real' environment and wanted to communicate his years of experience in a practical way...
It's one of those rare books written by somebody who's obviously used the product in a 'real' environment and wanted to communicate his years of experience in a practical way...
By A Customer
Format:Paperback
I've had this book for a couple of days now and I'm impressed. The book explains many concepts that a DBA will need to know if they are to fine tune a system and provides lots of good SQL code. It is repetitive, but in a positive sense i.e everything you need on a subject is there in one place rather than having to jump around from section to section (something that I find really annoying). This book will help new and experienced DBA's alike and will be a valuable addition to any DBA's bookshelf.
By A Customer
Format:Paperback
Well worth the money but I agree with others who suggest that there is a lot of repetition in the book. This doesn't make it bad, though. I found it to be very helpful in many areas and pulls together lots of different subject matter very well. The main grumble is that there is NO CD so I can't cut and paste the many snippets of SQL they provide. Still, I'd recommend this book over the competition if you're looking for something on performance/tuning.
On the issue of repetition, I find that many Oracle Series books seem to repeat, space things out well, print long code listings (even of large PL/SQLblocks) etc. It looks like they are desperately trying to write 1000 pages ! I note that one of the co-authors also wrote the Oracle Press reference book for web server which was even worse in this sense.
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 35 reviews
4.7 out of 5 stars
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
5.0 out of 5 stars
Ignore the critics and buy it.
Rich didn't state in this book that he's an accomplished author who spent his years in college English classes studying to become that. Read more
Published on 12 Dec 2001
5.0 out of 5 stars
Practical, informative, 0-60 miles in 5 secs
I started using this book this week and found it to be very practical, informative, and efficient compared to some others. Read more
Published on 22 Nov 1999 by kashkon@att.net
3.0 out of 5 stars
It is ok , but is inaccurate in several places
Having read it and attempted most of the examples I felt a little disappointed to the contents. Some of the examples are inaccurate, some one would not use and wonders how such an... Read more
Published on 26 Aug 1999
5.0 out of 5 stars
This is a great book!
One of the best in the series. You don't need to read the whole book to benefit from it. It is well organized and easy to read. A superb reference book.
Published on 6 Aug 1999
4.0 out of 5 stars
Way better than the book from the ARROGANT of Aronoff
Awesome book. A lot to learn. Doesn't pitch a product or vendor. Ideal for the advanced oracle shops
Published on 5 Aug 1999
5.0 out of 5 stars
Expert�s tips and useful examples for immediate tuning
In his book, Rich has merged his many years of Oracle performance tuning expertise with advanced insider techniques in an easy-to-understand way. Read more
Published on 3 Aug 1999
3.0 out of 5 stars
A bit repetitive
I'm not as impressed as the other reviewers here. I'm not doubting Mr Niemiec's ability to tune Oracle databases, however this book has a couple of really bad points:
1:... Read more
Published on 12 July 1999
5.0 out of 5 stars
Hundreds of tips you can implement right now!
Richard Niemiec, an Oracle expert and top presenter at conferences, shares hundreds of real-world tips and insider secrets culled from over a decade of consulting expertise. Read more
Published on 8 July 1999
5.0 out of 5 stars
Must have! Immediately useful! Money in the bank.
I can not imagine anyone involved with ORACLE Database performance issues not wanting this book simply because Rich Niemiec wrote it. Read more
Published on 3 July 1999
4.0 out of 5 stars
good experts and good book, but not bug free
I have seen many oracle books, but I saw only one that teaches the "dbwr_io_slaves" properly, and that book is the Alomary's from Prentice Hall. Read more
Published on 29 Jun 1999
Listmania!
Look for similar items by category
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
