- Paperback: 336 pages
- Publisher: McGraw-Hill Education (16 September 2014)
- Language: English
- ISBN-10: 0071824820
- ISBN-13: 978-0071824828
- Product Dimensions: 18.8 x 1.8 x 23.1 cm
- Average Customer Review: Be the first to review this item
- Amazon Bestsellers Rank: #8,15,848 in Books (See Top 100 in Books)
Oracle PL/SQL Performance Tuning Tips & Techniques Paperback – Import, 16 Sep 2014
|Paperback, Import, 16 Sep 2014||
Frequently bought together
Customers who bought this item also bought
About the Author
Dr. Paul Dorsey is the founder and President of Dulcian, Inc. Dulcian specializes in Oracle client-server and web custom application development including developing new projects, auditing existing efforts, and rescuing failed projects. Paul is the Executive Editor of SELECT Magazine. He is the President of the New York Oracle Users Group. Paul and Peter Koletzke shared the Pinnacle Publishing Technical Achievement Award at ECO 95 for their work on a Forms template. Paul has won best presentation awards at both ECO and IOUW conferences and speaks at numerous Oracle conferences and user group meetings
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 mobile phone number.
What other items do customers buy after viewing this item?
|5 star (0%)|
|4 star (0%)|
|3 star (0%)|
|2 star (0%)|
|1 star (0%)|
Most helpful customer reviews on Amazon.com
The discussion and analysis is not a simple 'do it this way or your performance will really suck' but is generously supported by their own experiences. You couldn't ask for two more experienced authors.
The book covers provides historical perspectives on a number of their approaches. For instance, limitations in earlier releases affect many of our assumptions about performance tuning. They point out where the old practices/prejudices came from and roll it forward to the functionality available in today's 11g and 12c releases.
DBAs will benefit from the insights here, particularly when doing performing tuning. Astute developers will find the variety of examples and the strength of their arguments very helpful in writing their own code and affecting the work of their peers.
Finally, the friendly tone of the text (likely due to Arup Nanda's editing) makes it pleasant to read and easy to digest even of you don't use PL/SQL a lot.
- Ray Smith
Misha and Paul take the scientific route to performance, providing readers the how-and-why of effective performance. The first chapter sets the tone showing how performance is an aggregate typically of nine-steps from execution of code on the client side, through middleware, to server, and back again to the client. Learn how PL/SQL works from two of the best whose shared stories of actual issues underline the importance of performance planning and thinking.
Oracle database professionals rely upon PL/SQL to accomplish many important tasks. This book presents numerous opportunities to improve PL/SQL performance offering more than just code suggestions. Perhaps most importantly, each unit steps the reader through how to test and prove if an actual improvement has been made. Code examples include explanations of how to test results so that you know the impact of your actions. For each topic highlighted, the authors provide discussions of the tradeoffs being made; for instance, did CPU improve at the expense of I/O or vice-versa? Performance-related Oracle tools and instrumentation are explained and demonstrated clearly to illustrate and confirm results.
You can read this book straight through as I did, or, pick a specific topic like caching and skip around. However you choose to read this book you're sure to learn lots about PL/SQL performance and how you can improve your systems.
If you're looking for an introduction to PL/SQL, PL/SQL For Dummies, an introductory volume by the same authors, or Feuerstein's Oracle PL/SQL Programming are better places to start. If you're an experienced PL/SQL developer looking for ways to get the most out of your code, Oracle PL/SQL Performance Tuning Tips & Techniques is a must read.
Michael Olin, President
New York Oracle Users Group, Inc.