A quick and ready reference for performance issues associated with the Oracle Database, Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach presents ready solutions for problems.Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach Summary Of The Book Database administrators around the world are constantly in need of immediate solutions to performance problems. At such a time, the prospect of reading through a reference book in an attempt to understand and learn theory and then to go ahead and implement the solution may not always be the preferred option. To do away with this process in times of need, Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach presents the reader with ready problems and solutions. This problem-driven approach can enable the reader to quickly look up the solution and implement it instantly. Each chapter in the book is devoted to a specific problem domain. Within that domain is found the key to performing common tasks. The team of authors has provided “recipes” under each domain. These “recipes” indicate, using examples, how common tasks are to be performed. The solutions provided within each recipe are backed by theory and explanations which enable the reader to understand and arrive at a solution quickly. Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach contains chapters such as Tracing SQL Execution, Minimizing System Contention, Optimizing Instance Memory, Optimizing Table Performance, Creating Efficient SQL, Configuring the Optimizer, Manually Tuning SQL, Monitoring System Performance, Choosing and Optimizing Indexes, Troubleshooting the Database, and Executing SQL in Parallel. The salient features of the book include the use of real-life performance Oracle problems and time-tested solutions, and the provision of essential background information to each solution. Oracle Database administrators who desire for a ready manual that can offer solutions to different kinds of problems encountered in real life, will benefit the most from this book. About The Authors Sam Alapati is an Oracle Database administrator with vast experience. Sam Alapati’s books include Expert Indexing in Oracle Database 11g, RMAN Recipes for Oracle Database 12c, and Oracle WebLogic Server 11g Administration Handbook. Sam is an Oracle certified professional who currently manages Oracle databases at the headquarters of Boy Scouts of America in Texas. Darl Kuhn is an experienced Oracle database administrator is a senior DBA with Sun Microsystems. Darl’s books include Pro Oracle Database 11g Administration, Linux Recipes for Oracle DBAs, and Expert Indexing in Oracle Database 11g. Darl Kuhn is a graduate of Colorado State University. He has also taught software development and Oracle database administration at Regis University. Bill Padfield is a lead database administrator and Oracle Certified Professional Bill has authored another book called Expert Indexing in Oracle Database 11g. Bill Padfield also teaches database administration for graduate students at Regis University. He works at a telecommunications company in Denver as a lead database administrator.
Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers.
Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.
|Number Of Items||1|
|Number Of Pages||592|