Oracle Database 11g R2 Performance Tuning Cookbook and over one million other books are available for Amazon Kindle. Learn more
Buy New
$49.49
Qty:1
  • List Price: $54.99
  • Save: $5.50 (10%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Trade in your item
Get a $1.70
Gift Card.
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 Database 11gR2 Performance Tuning Cookbook Paperback – January 20, 2012


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$49.49
$45.49 $67.08
Amazon%20Web%20Services
Interested in Databases? Amazon Web Services provides fully managed relational and NoSQL database services. Get started for free.


Frequently Bought Together

Oracle Database 11gR2 Performance Tuning Cookbook + Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)
Price for both: $88.88

Buy the selected items together

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 85%). Print edition purchase must be sold by Amazon. Learn more.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 542 pages
  • Publisher: Packt Publishing (January 20, 2012)
  • Language: English
  • ISBN-10: 1849682607
  • ISBN-13: 978-1849682602
  • Product Dimensions: 9.2 x 7.5 x 1.1 inches
  • Shipping Weight: 2.1 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #1,642,743 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Ciro Fiorillo

Ciro Fiorillo is an IT professional and consultant with experience of more than a decade in different roles (developer, analyst, DBA, project manager, data and software architect) among software industries. He has worked on different technologies and architectures, such as Oracle, SQL Server, Delphi, C# and .NET Framework, C/C++, Java, PHP, COBOL, Fortran, and Tibco.

Ciro is currently employed as Lead Software and Data Architect with FinWin Srl, a software house specializing in banking and loans applications.

As a freelancer he writes articles for websites and printed magazines about software and computing, participates in workshops, and teaches C++ and Fortran parallel programming with Intel Software tools.

Ciro can be reached at ciro@cirofiorillo.com.


More About the Author

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

Customer Reviews

3.8 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

Format: Paperback Verified Purchase
I ordered the "Oracle Database 11gR2 Performance Cookbook" book shortly after it became available for purchase. I was very curious to see how the book compared with the similarly titled "Oracle Database 11g Performance Tuning Recipes" book, as well as some of the other Oracle Database performance books that are on the market. Packt is a fairly new book publisher, and this book marks the first Packt book in my collection.

The author of this book does not appear to be widely known in the international Oracle Database community, although it does appear that the author is an active reviewer of SQL Server and programming books on an Italian programming focused website. The author's LinkedIn page indicates that he obtained OCA and OCP certification in 2002 and 2003, respectively, has a variety of programming experience, and currently is an IT Manager.

One important characteristic of this book that is missing from some of the other Oracle Database performance focused books on the market is the extensive use of test case scripts throughout most of the book that allow the reader to reproduce the performance changes mentioned in the book, in the reader's Oracle Database environments. The test case scripts, related screen captures, and author's explanations of the results are both a blessing and a curse for this book. It appears that the author used a single Amazon Elastic Compute Cloud hosted database instance with only one set of instance parameters and system statistics for the various test case results and the author's descriptions of the expected outcome when the inputs in the test case script are provided.
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
1 of 1 people found the following review helpful By W Boudville HALL OF FAMETOP 1000 REVIEWERVINE VOICE on February 18, 2012
Format: Paperback
This is a very detailed text by Fiorillo on how to improve the performance of your 11gR2 database. It presupposes that you are a database administrator already versed in the basics of 11g.

The first chapter is the simplest, and possibly offers the quickest improvements to your system. It has many guidelines. Like warning that an academic design of an abstract database could map badly into the relational structure of an actual Oracle database. Beware of over normalisation, we are told. Where too many table joins happen. This can sometimes be traced back to having too many tables. The latter can arise due to an elegant factoring of a problem, or to the mapping of an object oriented design to a relational database. In general, fewer tables can be better, even if this incurs extra columns as it usually will.

You should also look at and understand how the alert log works. A vital feedback if you want to adjust your table structures and measure actual performances.

The second chapter contains sections that can seem like heresy to those of you taught to observe or create the Normal Forms. The text warns that sometimes poor performance can result. Oracle lets you define tables that do not even follow the 1NF!

A very interesting section explains the differences between static and dynamic SQL. The former is hardcoded in application source code, while the latter is calculated (interpreted) at runtime. You are cautioned to only occasionally run dynamic SQL. It can be very slow.

Later chapters delve into other topics. As in how to optimise storage under Oracle. Or to optimise SQL code. Each of these warrants its own chapter, as an indication of their importance.
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
By Joseph Opoku on June 14, 2013
Format: Paperback Verified Purchase
This is one of the best Oracle Performance book I have read. The recipes are simple and easy to understand.
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
0 of 3 people found the following review helpful By S. Sutton on March 14, 2012
Format: Paperback Verified Purchase
This will help you with the "what", as in "what should we do?", and it does a pretty good job at providing examples for tuning queries, indexes, and the database as a whole. Unfortunately for me, it's completely lacking the "why", as in "why did whatever they had me do just speed things up?".

It's great if you just want to bang out some performance tuning, it's not so great if you want to learn from that experience and pro-actively apply it to future applications.
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