Industrial-Sized Deals TextBTS15 Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Deradoorian $5 Off Fire TV Stick Grocery pivdl pivdl pivdl  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Gear Up for Football STEM Toys & Games
Try Free
$0.00
Buy
$32.67

Deliver to your Kindle or other device

Flip to back Flip to front
Audible Narration Playing... Paused   You are listening to a sample of the Audible narration for this Kindle book.
Learn more

Oracle PL/SQL Performance Tuning Tips & Techniques Kindle Edition

8 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
$32.67

Length: 336 pages Optimized for larger screens
  • Due to its large file size, this book may take longer to download

Kindle Daily Deals
Kindle Delivers: Daily Deals
Subscribe to find out about each day's Kindle Daily Deals for adults and young readers. Learn more (U.S. customers only)

Editorial Reviews

About the Author

Michael Rosenblum is a Software Architect/Senior DBA at Dulcian, Inc., where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, Michael received the scholarship of the president of Ukraine, a master of science degree in information systems, and a diploma with honors from the Kiev National University of Economics.

Dr. Paul Dorsey is the founder and president of Dulcian, Inc., an Oracle consulting firm specializing in business rules and web-based application development. He is the chief architect of Dulcian's Business Rules Information Manager (BRIM®) tool. Dr. Dorsey is the co-author of seven Oracle Press books on Designer, Database Design, Developer, and JDeveloper, which have been translated into nine languages. He is an Oracle Fusion Middleware Regional Director. Paul is President Emeritus of NYOUG and the Associate Editor of the International Oracle User Group's SELECT Journal. In 2003, Dr. Dorsey was honored by ODTUG as volunteer of the year, in 2001 by IOUG as volunteer of the year, and by Oracle as one of the six initial honorary Oracle 9i Certified Masters. Dr. Dorsey is also the founder and Chairperson of the ODTUG Symposium, currently in its eighth year. His submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge.


Product Details

  • File Size: 26702 KB
  • Print Length: 336 pages
  • Publisher: McGraw-Hill Education; 1 edition (August 29, 2014)
  • Publication Date: August 29, 2014
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B00LI363FE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Amazon Best Sellers Rank: #193,182 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), contributing author of Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the president of Ukraine, a master of science degree in information systems, and a diploma with honors from the Kiev National University of Economics.

Customer Reviews

5 star
88%
4 star
0%
3 star
0%
2 star
0%
1 star
12%
See all 8 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

4 of 4 people found the following review helpful By Bokonen on August 30, 2014
Format: Paperback
Misha and Dr. Dorsey follow a very effective pattern in this manual: Each topic is introduced and all of the options are laid out, then they illustrate the performance impacts of those varfious options. They share the code for each example so that we can use to prove the performance differences for ourselves to our peers.

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
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
Format: Kindle Edition
"Oracle PL/SQL Performance Tuning Tips & Techniques" by Michael Rosenblum and Dr. Paul Dorsey is a book you should read soon. A quote from Oracle's Bryn Llwellyn in the book's forward says it all "Every professional PL/SQL programmer should study this book and act upon its teachings."
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.
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
3 of 4 people found the following review helpful By Patrick Cimolini on September 9, 2014
Format: Paperback
Bryn Llewellyn's insightful forward ends with "Every professional PL/SQL programmer should study this book and act upon its teachings." After reading this book, cover to cover, I heartily agree. I am a developer; this book has given me insights into the inner workings of PL/SQL which will make me more effective when I write PL/SQL code. In addition, it has given me knowledge and vocabulary that will help me communicate more effectively with the DBAs on my team. This book is a five star addition to my professional library.
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
Format: Paperback
This (relatively) thin book had been sitting on my desk unread, taunting me since it arrived this summer. Now the leaves have turned, the book has been read, and I can move it to my bookshelf as it certainly deserves a spot next to my collection of Steven Feuerstein's classic PL/SQL works. Let's start with what Oracle PL/SQL Performance Tuning Tips & Techniques is not. This book is not a step-by-step primer on how to tune PL/SQL. It does not provide a guide for analyzing trace output and diagnosing the cause of wait events in the database. Instead, authors Rosenblum and Dorsey start by describing the many vectors by which performance problems can arise in modern multi-tiered architectures. They then describe tools and techniques that can be applied to instrument code and measure performance. Once this groundwork has been laid, they proceed in a most interesting direction. Rather than chapter after chapter of tried-and-true techniques for making incremental improvements to performance based on the results of timed executions and traces, the reader instead finds, as the subtitle promises, "Best Practices for Improving Overall Speed, Reliability and Security". The authors are both Oracle ACEs with years of experience developing applications using a "thick database" paradigm. Most of the book describes the techniques that they have developed to allow the database to efficiently do the heavy lifting, minimizing the work that needs to be done by the application server or client. These techniques support the development of efficient, scalable applications, which do most of the work on the most powerful component of the multi-tier architecture, the database server. The book includes many techniques that I've used myself and quite a few that were new to me.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

Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


What Other Items Do Customers Buy After Viewing This Item?