Secrets of the Oracle Database (Paperback)

Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.

What you’ll learn

• Take advantage of Oracle’s built–in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more.
• Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure.
• Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely–documented repository, and integrating with SQL Trace.
• Take control of your instance through the ill–documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more.
• Leverage undocumented features in Oracle’s built–in scheduler to better automate your workload.
• Take full advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.

Who is this book for?

Secrets of the Oracle Database is written for database administrators and developers well past the beginner level who desire to take full advantage of the power the Oracle platform has to offer. The book is by no means an introductory book. Readers should already be familiar and comfortable with SQL and PL/SQL, and should have a good grounding in Oracle database architecture.

《Oracle Database 的秘密》是關於 Oracle 資料庫伺服器未記錄或部分記錄的功能的權威指南。本書涵蓋了從 Oracle9i Database 到 Oracle Database 11g 的有用但鮮為人知的功能，將提升您作為 Oracle 資料庫管理員或開發人員的效率。Norbert Debes 為您揭示了一些能夠幫助您掌握比您想像中更困難的管理、調優和故障排除任務的功能。

終於，在這裡，您可以輕鬆獲得以前只能通過多年的經驗和口耳相傳才能獲得的知識。Norbert 所寫的內容準確、經過良好測試，並以清晰的示例進行了詳細說明，肯定能提升您在日常與 Oracle 工作中產生影響的能力。

您將學到什麼：
- 利用 Oracle 內建的 Perl DBI 發行版編寫用於監控、基準測試、數據提取等應用程式。
- 解讀未記錄的擴展追蹤文件格式，以找出 TKPROF 報告忽略和模糊的性能問題。
- 通過使用未記錄的報告格式選項、訪問其稀缺記錄的存儲庫以及與 SQL 追蹤集成，充分利用 Statspack。
- 通過使用鮮為人知的 ORADEBUG 命令來控制實例，使您能夠控制進程、追蹤 SQL 語句、轉儲進程狀態、監視等待事件和呼叫堆棧等。
- 利用 Oracle 內建調度器的未記錄功能更好地自動化工作負載。
- 在實際應用程式集群環境中充分利用透明應用程式故障轉移和集群資料庫服務。

這本書適合對象：
《Oracle Database 的秘密》是為那些已經超越初學者水平，希望充分利用 Oracle 平台威力的資料庫管理員和開發人員而寫的。本書絕不是一本入門書。讀者應該已經熟悉並熟練使用 SQL 和 PL/SQL，並對 Oracle 資料庫架構有良好的基礎。