Secret ORACLE - Unleashing the Full Potential of the ORACLE DBMS by Leveraging Undocumented Features (Paperback)

Norbert Debes

  • 出版商: Lulu.com
  • 出版日期: 2008-03-23
  • 售價: $1,840
  • 貴賓價: 9.5$1,748
  • 語言: 英文
  • 頁數: 404
  • 裝訂: Paperback
  • ISBN: 1435705513
  • ISBN-13: 9781435705517
  • 相關分類: Oracle
  • 海外代購書籍(需單獨結帳)

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

相關主題

商品描述

Secret ORACLE is the definitive guide to undocumented and partially documented features of the ORACLE database server. This book will improve your efficiency as an ORACLE database administrator and enable you to master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Topics covered include: The MERITS performance optimization method, which extends the state-of-the-art wait event tuning paradigm. Controlling processes of an ORACLE instance with the fragmentarily documented ORADEBUG command to trace SQL statements as well as wait events and dump process state, call stack, and hang analysis information. Tracing the cost based optimizer to understand its cost calculations and decisions. Understanding hidden parameters that govern Automatic PGA Memory Management. Leveraging undocumented features of the Oracle10g/11g scheduler and other partially or fully undocumented PL/SQL packages, such as DBMS_SYSTEM, DBMS_SUPPORT, and DBMS_UTILITY.

商品描述(中文翻譯)

《Secret ORACLE》是一本關於 ORACLE 資料庫伺服器未記錄及部分記錄功能的權威指南。本書將提升您作為 ORACLE 資料庫管理員的效率,並使您能夠掌握比您想像中更具挑戰性的管理、調優和故障排除任務。涵蓋的主題包括:MERITS 性能優化方法,擴展了最先進的等待事件調優範式。使用部分記錄的 ORADEBUG 命令控制 ORACLE 實例的進程,以追蹤 SQL 語句及等待事件,並轉儲進程狀態、調用堆疊和掛起分析資訊。追蹤基於成本的優化器,以了解其成本計算和決策。理解控制自動 PGA 記憶體管理的隱藏參數。利用 Oracle10g/11g 調度器的未記錄功能及其他部分或完全未記錄的 PL/SQL 套件,如 DBMS_SYSTEM、DBMS_SUPPORT 和 DBMS_UTILITY。