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.
To get the free app, enter your email address or mobile phone number.
Oracle Database 11gR2 Performance Tuning Cookbook Paperback – January 20, 2012
|New from||Used from|
O'Reilly Media's Brand Store
Check out these featured titles from O'Reilly Media.
Customers Who Viewed This Item Also Viewed
About the Author
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 firstname.lastname@example.org.
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.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.
Top Customer Reviews
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 ›
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 ›
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.