Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

Description

Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.” Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes • “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization • Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance • Highly efficient database logical and physical design, indexing, transaction design, and API use • SQL and PL/SQL tuning, including the use of parallel SQL techniques • Minimizing contention for locks, latches, shared memory, and other database resources • Optimizing memory and physical disk IO • Tuning Real Application Cluster (RAC) databases guyharrison.net informit.com/ph

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Oracle Performance Survival Guide

  By Harrison

  Oracle Performance Survival Guide

• 

  Oracle Exadata Survival Guide

  By Mary Spence, David Fitzjarrell

  The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more.

• 

  Oracle ADF Survival Guide: Mastering the Application Development Framework

  By Sten Vesterli

  The book: Explains all parts of the ADF stack Shows how to integrate with databases and web services Demonstrates the best practice for ADF enterprise architecture What You Will Learn Rapidly build great-looking, user-friendly screens Build ...

• 

  Oracle Database 12c Backup and Recovery Survival Guide

  By Aman Sharma, Francisco Munoz Alvarez

  This book is designed for Oracle DBAs and system administrators.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the ...

• 

  PeopleSoft for the Oracle DBA

  By David Kurtz

  This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.

• 

  Oracle Parallel Processing

  By Sanjay Mishra, Tushar Mahapatra

  Parallel processing is becoming increasingly important to database computing. Databases often grow to enormous sizes and are accessed by huge numbers of users. This growth strains the ability of single-processor...

• 

  Next Generation Databases: NoSQLand Big Data

  By Guy Harrison

  Document databases that support XML document formats have been primarily important as content management systems, providing a management repository for XML-based text files. JSON document databases, on the other hand, use JSON documents ...

• 

  MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

  By Steven Feuerstein, Guy Harrison

  A full tutorial on J2EE database programming is beyond the scope of this book (and probably beyond the expertise of its authors). However, in this section we will take a quick look at how you might use stored programs within a J2EE ...

• 

  MongoDB Performance Tuning: Optimizing MongoDB Databases and their Applications

  By Michael Harrison, Guy Harrison

  What You Will Learn Apply a methodical approach to MongoDB performance tuning Understand how to design an efficient MongoDB application Optimize MongoDB document design and indexing strategies Tune MongoDB queries, aggregation pipelines, ...

• 

  Oracle Database 11G - Underground Advice for Database Administrators

  By April C. Sims

  A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook.