Oracle PL/SQL Performance Tuning Tips & Techniques (Paperback)

Proven PL/SQL Optimization Solutions

In Oracle PL/SQL Performance Tuning Tips & Techniques, Oracle ACE authors with decades of experience building complex production systems for government, industry, and educational organizations present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery process required to pinpoint performance problems and then provides measurable and repeatable test cases. In-depth coverage of linking SQL and PL/SQL is followed by deep dives into essential Oracle Database performance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide.

• Follow a request-driven nine-step process to identify and address performance problems in web applications
• Use performance-related database tools, including data dictionary views, logging, tracing, PL/SQL Hierarchical Profiler, PL/Scope, and RUNSTATS
• Instrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers
• Embed PL/SQL in SQL and manage user-defined functions
• Embed SQL in PL/SQL using a set-based approach to handle large volumes of data
• Properly write and deploy data manipulation language triggers to avoid performance problems
• Work with advanced datatypes, including LOBs and XML
• Use caching techniques to avoid redundant operations
• Effectively use dynamic SQL to reduce the amount of code needed and streamline system management
• Manage version control and ensure that performance fixes are successfully deployed

Code examples in the book are available for download.

《Oracle PL/SQL 效能調校技巧與方法》是一本由擁有數十年經驗在政府、工業和教育機構建立複雜生產系統的 Oracle ACE 作者所撰寫的書籍。本書以實踐方法介紹如何在 PL/SQL 中獲得最佳效能。首先，書中描述了發現性能問題所需的探索過程，並提供可衡量和可重複的測試案例。接著深入介紹了連接 SQL 和 PL/SQL 的重要 Oracle Database 效能調校工具。全書充滿了真實世界的例子和最佳實踐。

本書的內容包括：
- 遵循九個步驟的請求驅動流程，以識別和解決網絡應用程式的性能問題
- 使用與性能相關的資料庫工具，包括資料字典檢視、日誌記錄、追蹤、PL/SQL 階層分析器、PL/Scope 和 RUNSTATS
- 使用呼叫堆疊 API、錯誤堆疊 API 和時間標記來定位性能問題
- 將 PL/SQL 嵌入 SQL 並管理使用者定義函數
- 使用基於集合的方法將 SQL 嵌入 PL/SQL 以處理大量資料
- 正確編寫和部署資料操作語言觸發器以避免性能問題
- 使用高級資料類型，包括 LOB 和 XML
- 使用快取技術避免重複操作
- 有效使用動態 SQL 減少所需的程式碼量並簡化系統管理
- 管理版本控制，確保性能修復成功部署

本書提供了可下載的程式碼範例。