Oracle Database Performance and Scalability

02/15/2013 · No Responses

A data-driven, fact-based, quantitative text on Oracle performance and scalability

With database concepts and theories clearly explained in Oracle’s context, readers quickly learn how to fully leverage Oracle’s performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author’s more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques.

Oracle Database Performance and Scalability is divided into four parts that enable readers to progressively learn and apply new skills:

Part 1, Getting Started with Oracle, describes how to set up a working Oracle environment, offering a quick tour to illustrate major database concepts
Part 2, Oracle Architecture from Performance and Scalability Perspectives, explains all the major database concepts and architectural features that readers need to know to optimize Oracle performance and scalability
Part 3, Optimizing Oracle Performance and Scalability, offers hands-on instructions to optimize and fine-tune performance and scalability for all database applications
Part 4, Case Studies: Oracle Meeting Real-World Performance and Scalability Challenges, sets forth quantitative case studies based on the author’s first-hand experience that demonstrate how readers can apply proven techniques to dramatically improve the performance and scalability of actual database products

In addition to case studies, this book offers a detailed secure online banking application as an example, making it possible for readers to fully explore Oracle’s performance and scalability features on their own. Oracle Database Performance and Scalability is an ideal text for pre-conditioning college students and training software developers.

Table of Contents
PART I: GETTING STARTED WITH ORACLE
Chapter 1. Basic Concepts
Chapter 2. Installing Oracle Software
Chapter 3. Options for Accessing an Oracle Server
Chapter 4. A Quick Tour of an Oracle Server

PART II: ORACLE ARCHITECTURE FROM PERFORMANCE AND SCALABILITY PERSPECTIVES
Chapter 5. Understanding Oracle Architecture
Chapter 6. Oracle 10g Memory Management
Chapter 7. Oracle 11g Memory Management
Chapter 8. Oracle Storage Structure
Chapter 9. Oracle Wait Interface (OWI)
Chapter 10. Oracle Data Consistency and Concurrency
Chapter 11. Anatomy of an Oracle Automatic Workload Repository (AWR) Report
Chapter 12. Oracle Advanced Features and Options
Chapter 13. Top 10 Oracle Performance and Scalability Features
Chapter 14. Oracle-Based Application Performance and Scalability by Design
Chapter 15. Project: Soba—A Secure Online Banking Application on Oracle

PART III: OPTIMIZING ORACLE PERFORMANCE AND SCALABILITY
Chapter 16. Logistics of the Oracle Cost-Based Optimizer (CBO)
Chapter 17. Oracle SQL Tuning
Chapter 18. Oracle Indexing
Chapter 19. Auto_Tune Features

PART IV: CASE STUDIES: ORACLE MEETING REAL WORLD PERFORMANCE AND SCALABILITY CHALLENGES
Chapter 20. Case Study: Achieving High Throughput with Array Processing
Chapter 21. Case Study: Performance Comparison of Heap-Organized versus Index-Organized Tables
Chapter 22. Case Study: SQL Tuning: “IN” versus “OR” versus Global Temporary Table
Chapter 23. Case Study: Data Access Paths (Double Buffering)
Chapter 24. Case Study: Covering Index
Chapter 25. Case Study: CURSOR_SHARING
Chapter 26. Case Study: Bulk Transactions
Chapter 27. Case Study: Missing Statistics
Chapter 28. Case Study: Misconfigured SAN Storage