Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Paperback)

Richard Niemiec

  • 出版商: McGraw-Hill Education
  • 出版日期: 2012-03-19
  • 售價: $2,540
  • 貴賓價: 9.5$2,413
  • 語言: 英文
  • 頁數: 1184
  • 裝訂: Paperback
  • ISBN: 0071780262
  • ISBN-13: 9780071780261
  • 相關分類: Oracle資料庫
  • 海外代購書籍(需單獨結帳)

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

商品描述

Implement Proven Database Optimization Solutions

Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.

  • Properly index and partition Oracle Database 11g Release 2
  • Work with Oracle Exadata and Oracle Exalogic Elastic Cloud
  • Efficiently manage disk drives, RAID arrays, and memory
  • Tune queries with Oracle SQL hints and the TRACE utility
  • Troubleshoot databases using V$ views and X$ tables
  • Distribute workload using Oracle Real Application Testing
  • Generate reports using Oracle's Statspack and Automatic Workload Repository tools
  • Use sar, vmstat, and iostat to monitor system statistics

商品描述(中文翻譯)

實施經過驗證的資料庫優化解決方案

請Oracle認證大師Richard Niemiec協助,系統性地識別並消除資料庫性能問題。《Oracle Database 11g Release 2 Performance Tuning Tips & Techniques》充滿了實際案例和最佳實踐,詳細介紹了最新的監控、故障排除和優化方法。了解如何找到並修復瓶頸,配置存儲設備,執行高效的查詢,以及開發無錯誤的SQL和PL/SQL代碼。本書還介紹了測試、報告和安全增強功能。


  • 正確索引和分區Oracle Database 11g Release 2

  • 與Oracle Exadata和Oracle Exalogic Elastic Cloud一起工作

  • 高效管理磁盤驅動器、RAID數組和內存

  • 使用Oracle SQL提示和TRACE實用程序調整查詢

  • 使用V$視圖和X$表故障排除資料庫

  • 使用Oracle Real Application Testing分發工作負載

  • 使用Oracle的Statspack和Automatic Workload Repository工具生成報告

  • 使用sar、vmstat和iostat監控系統統計數據