Oracle Performance Tuning: Database Management Systems (Nutshell Handbooks) 2nd Edition

by Mark Gurry (Author), Peter Corrigan (Author)

14 customer reviews

ISBN-13: 978-1565922372

ISBN-10: 1565922379

Why is ISBN important?

Have one to sell? Sell on Amazon

Condition: Used - Very Good

In Stock. Sold by Jenson Books Inc, Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

31 Used from $2.97

FREE Shipping on orders over $25.

Turn on 1-Click ordering

Only 1 left in stock - order soon.

Ships from and sold by Amazon.com. Gift-wrap available.

20 New from $10.00

FREE Shipping.

Turn on 1-Click ordering

Ship to:

Select a shipping address:

More Buying Choices

20 New from $10.00 31 Used from $2.97 1 Collectible from $10.95

52 used & new from $2.97

See All Buying Options

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now.Performance tuning is crucial in any modern relational database management system. Too many organizations respond to Oracle performance problems by throwing money at these problems -- by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running -- from Version 6 to Oracle8, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades.The first edition of Oracle Performance Tuning became a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition contains 400 pages of updated material updating on Oracle features, incorporating advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.

Oracle Performance Tuning: Database Management Systems (Nutshell Handbooks)

$79.62 FREE Shipping. Only 1 left in stock - order soon. Ships from and sold by Amazon.com. Gift-wrap available.

What other items do customers buy after viewing this item?

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) Paperback

Richard Niemiec

30

$35.96
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities Paperback

Kevin Meade

32

$38.22

Editorial Reviews

From the Publisher

The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now. Performance tuning is crucial in any modern relational database management system. Too many organizations respond to Oracle performance problems by throwing money at these problems -- by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running -- from Version 6 to Oracle8, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades. The first edition of Oracle Performance Tuning has become a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition is a complete rewrite; it adds 400 pages to the first edition, updating all the original information, incorporating new advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes new chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.

From the Back Cover

The first edition of Oracle Performance Tuning has become a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition is a complete rewrite; it updates all the original information, incorporating new advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPs, SMPs, and other architectures. It also includes new chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.

See all Editorial Reviews

Product details

Series: Nutshell Handbooks
Paperback: 966 pages
Publisher: O'Reilly Media; 2 edition (November 11, 1996)
Language: English
ISBN-10: 1565922379
ISBN-13: 978-1565922372
Product Dimensions: 7 x 2.4 x 9.2 inches
Shipping Weight: 3.2 pounds (View shipping rates and policies)
Average Customer Review: 14 customer reviews
Amazon Best Sellers Rank: #3,238,512 in Books (See Top 100 in Books)
- #705 in Books > Computers & Technology > Databases & Big Data > Data Warehousing
- #738 in Books > Computers & Technology > Databases & Big Data > Oracle
- #1451 in Books > Computers & Technology > Databases & Big Data > Data Mining

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

NO_CONTENT_IN_FEATURE

Customer reviews

2 star

1 star

Write a customer review

See all 14 customer reviews

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

This is a good book, but misses on Statspack/AWR analysis

Byjava_rwon November 24, 2011

Format: Paperback

This is a good beginner book, that covers basics of oracle performance tuning. At the same time, it does not covers statspack or AWR (only basic utlbstats/utlestat). Working with Oracle for the last 20+ years, I found Oracle statspack and AWR irreplaceable analysis tools. These tools actually enable DBAs to quantify performance impact of the bottlenecks and clearly see root causes of performance degradation. This is especially important for analysis of oracle RAC systems, as quite frequently, activity on one of the instances negatively impacts other RAC nodes or even causing instance eviction.

I have tried number of tools to analyze AWR and statspack data, including native Oracle EM (Enterprise manager). So far, I have found that Enteros' Performance Explorer-i (from [...]) provides best and state of the art performance analysis capabilities for statspack and AWR data. Usually, work of hours with AWR or statspack reports is compressed into minutes by using proprietary Enteros' spike analysis, that analyses hundreds of metrics together and provide clear picture of performance bottleneck development and correlations. Performance Explorer-i also enable me to perform automatic cross-instance analysis for RAC instances, which is extremely important for resolution of complext issues.

Also, many DBA not changing standard collection period and retention of AWR snapshots (1 hour and 7 days). I strongly recommend to change them to 15 minutes and 4 month correspondingly

0CommentWas this review helpful to you?YesNo

Great text, but watch those typos!

ByA customeron March 25, 1999

Format: Paperback

This text offers many, many pieces of good advice and many insights into the internals of the Oracle server. It is one of the the top two or three book s on the subject and as such, is easy to recommend. BUT, be very careful of most example scripts. Many have syntax errors (which is strange , given they are clearly 'cut and paste' from a screen dump). If you are an experienced DBA, you will spot them on reading. At worst they will be obvious when they generate an error. However for the less experienced, there could be some frustrating moments. This is very disappointing for the second edition of a book (some of the grammar leaves alot to be desired too!). Also on the downside, the book claims to include updates for Oracle 8, but this is a rather generous claim, Many examples or recommendations are redundant in an Oracle 8 environment but are not identified as such. Overall though, still a worthwhile part of any DBA's toolkit.

0Comment 9 people found this helpful. Was this review helpful to you?YesNo

Helpful

ByVinicio Valenciaon June 3, 2001

Format: Paperback

This book has a lot of Oracle tuning tips and advise about some certain plattforms and technologies. Although there's a lot of considerable information about almost anything related with Oracle tuning (including OPS), it doesn't provide with a concise method or guide.
The book is structured to help you at different stages of your Oracle implementation (design phase, production, proactive and reactive tuning, capacity planning, etc). But that good schema looks very confuse when the author starts to make suggestions or tips that aren't sorted by any kind of category (and they often takes a lot of pages)... Those comments are very good, so it needs a bit of more organization.
I recommend this book for instance and database tuning, but not for SQL tuning (the author has another excellent book on this subject). There aren't too many advices regarding the plattform (unix or nt), so, keep in mind you'll need more support.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

A little out of date, a few typos, but the best you can get

Byianon February 1, 2000

Format: Paperback

I have been using a copy of this book for a couple of years now, and I have still kept it as my 'good tricks' bible since becoming being a certified Oracle dba. Ok, so not all the queries run first time as given, and the book is really about Oracle 7, but this is still the first reference book I turn to whenever another dba comes up with a 'I've tried everything to do this, but nothing works' type question. A very good book to read if you want to know how to make Oracle work for you.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

Great book, should be added to your collection.

ByMayo@hotdata.comon January 21, 1998

Format: Paperback

This book has helped me quickly go from an beginning/intermediate level Oracle developer to an advanced developer. It has allowed me to quickly debug and correct real world performance problems under both Oracle 7.3 and Oracle 8.0. This was the forth Oracle performance related book I purchased and it has been ten times as helpful and insightful as the other three combined. This book is easy to understand and broken down in to very logic chapters. I can't say enough about this book. I would definitely add this to your collection!

0Comment One person found this helpful. Was this review helpful to you?YesNo

How Much Tuning is Enough?

ByAndy.Duncan@btinternet.comon September 22, 1998

Format: Paperback

To say this book is only about 'Performance Tuning' would be like saying 'The Complete Works of Shakespeare' were only about Elizabethan England. As an Oracle DBA contractor, who's switched from Informix, this book was invaluable in bringing me onside with how 'Oracle' works. I have purchased a large number of Oracle texts from Amazon in the past, mostly from the Osborne and O'Reilly ranges. If for some mysterious reason, they were all to be 'borrowed' one day without trace, this would be the first one I would re-buy.

0Comment 6 people found this helpful. Was this review helpful to you?YesNo

One of my favorite - but needs to be updated for Oracle8i

ByBernie Wongon March 30, 2001

Format: Paperback

The first edition, or as we affectionately called it, the "Bee" book was the bible. I recently bought the 2nd edition for old times sake. It still has a lot of good info but sorely needs to be updated. There are many Oracle8i performance features such as tempfile for temporary files that are not mentioned. Instead, I am turning to more recent text like Oracle8i & Unix Perf Tuning by Ahmed Alomari and Oracle Perf Tuning Tips by Richard Niemiec. Mark, loved your books. Can't wait for the updates.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

This book made me some bucks

ByJohn M. Harbyon February 4, 2001

Format: Paperback

Many of the tricks and approaches offered in here can enable you to perform some impressive rescuing of slow applications. Management tends to like this quite a bit. Having had this book from way back, there were many tips in there that were not available from the standard Oracle documentation such as making a query return unique records by using the rowid in the where clause. If you're in a database-centric development or DBA position, I wholeheartedly recommend this book.

0Comment 2 people found this helpful. Was this review helpful to you?YesNo

Most recent customer reviews

Badly needs updating, typos corrected and much better index

This is the best overall book on Oracle Tuning but the editors were sloppy in weeding out the typos--no excuse for a second edition book.Read more

Published on June 10, 2000

Good book, but...

While this book is an in-depth reference for Oracle performance tuning, it could benefit from more concrete examples.Read more

Published on December 15, 1998

Bible for Performance Tuning

The First and the last book on Performance Tuning

Published on October 8, 1998

Excellent!!! Cannot do without it.

Great scripts - really come in handy. Very good tuning and troubleshooting tips and techniques. Has saved me and made me look good on numerous occassions.Read more

Published on September 17, 1998

Something for everyone.

This book was recommended by a friend but, when I started reading it, I thought they were pulling my leg.Read more

Published on August 5, 1998

Excellect book for increasing Oracle performance

I found this book to be extremely insightful with respect to Oracle internals and how to tune both the data base as well as queries.Read more

Published on August 2, 1998 by Bob

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway

This item: Oracle Performance Tuning: Database Management Systems (Nutshell Handbooks)

Set up a giveaway

Pages with related products. See and discover other items: pay for performance, sql database management

Oracle Performance Tuning: Database Management Systems (Nutshell Handbooks) 2nd Edition

Buy used On clicking this link, a new layer will be open $9.50 On clicking this link, a new layer will be open

Turn on 1-Click ordering

Buy new On clicking this link, a new layer will be open $79.62 On clicking this link, a new layer will be open

Turn on 1-Click ordering

or

or

What other items do customers buy after viewing this item?

Editorial Reviews

From the Publisher

From the Back Cover

Product details

Customer reviews

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

Most recent customer reviews

Set up an Amazon Giveaway

Buy used On clicking this link, a new layer will be open

$9.50 On clicking this link, a new layer will be open

Buy new On clicking this link, a new layer will be open

$79.62 On clicking this link, a new layer will be open