Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Paperback)

Guy Harrison

  • 出版商: Prentice Hall
  • 出版日期: 2009-10-01
  • 售價: $2,470
  • 貴賓價: 9.5$2,347
  • 語言: 英文
  • 頁數: 768
  • 裝訂: Paperback
  • ISBN: 0137011954
  • ISBN-13: 9780137011957
  • 相關分類: Oracle資料庫
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

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

 

 

 

商品描述(中文翻譯)

《Oracle性能生存指南》

《Oracle性能生存指南》提供了一套結構化、系統化的方法,以最高效的方式優化Oracle性能。領先的Oracle專家Guy Harrison展示了如何通過關注原因而不是症狀,並快速識別出帶來最大效益的領域,從而最大化調優投資。

Harrison針對具有不同經驗水平的DBA和開發人員撰寫,涵蓋了Oracle性能管理的各個方面,從應用程序設計到SQL調優,從競爭管理到內存和物理IO管理。他還提供了關於優化Oracle 11g Release 2性能的最新指導。

您將首先掌握Oracle結構化性能調優原則和工具,包括追踪和監控Oracle執行的技術。Harrison闡明了應用程序和數據庫之間的交互作用,指導您選擇調優工具,並介紹了能夠實現更高性能應用程序的前期設計技術。他還提供了一系列可下載的腳本,用於報告數據庫性能的各個方面。

內容包括:

- "按層調優",這是Oracle性能優化最有效、價值最高的方法
- 充分利用Oracle的追踪、監控和診斷性能的核心工具
- 高效的數據庫邏輯和物理設計、索引、事務設計和API使用
- SQL和PL/SQL調優,包括並行SQL技術的使用
- 減少鎖、閂、共享內存和其他數據庫資源的競爭
- 優化內存和物理磁盤IO
- 調優實時應用集群(RAC)數據庫

guyharrison.net
informit.com/ph