- Why This Book
- Who This Book is For
- How This Book is Organized
- Software and Hardware
- How to Use This Book
- How to Reach The Author
- Acknowledgments
Introduction
- Features of Oracle
- Objectives
- Conventions
- Performance versus Scalability
PART 1 GETTING STARTED WITH ORACLE
- 1 Basic Concepts
- 2 Installing Oracle Software
- 3 Options for Accessing an Oracle Server
- 4 A Quick Tour of an Oracle Server
PART 2 ORACLE ARCHITECTURE FROM PERFORMANCE AND SCALABILITY PERSPECTIVES
- 5 Understanding Oracle Architecture
- 6 Oracle 10g Memory Management
- 7 Oracle 11g Memory Management
- 8 Oracle Storage Structure
- 9 Oracle Wait Interface (OWI)
- 10 Oracle Data Consistency and Concurrency
- 11 Anatomy of an Oracle Automatic Workload Repository (AWR) Report
- 12 Oracle Advanced Features and Options
- 13 Top 10 Oracle Performance and Scalability Features
- 14 Oracle-Based Application Performance and Scalability by Design
- 15 Project: Soba—A Secure Online Banking Application on Oracle
PART 3 OPTIMIZING ORACLE PERFORMANCE AND SCALABILITY
- 16 Logistics of the Oracle Cost-Based Optimizer (CBO)
- 17 Oracle SQL Tuning
- 18 Oracle Indexing
- 19 Auto-Tune Features
PART 4 CASE STUDIES: ORACLE MEETING REAL WORLD PERFORMANCE AND SCALABILITY CHALLENGES
- 20 Case Study: Achieving High Throughput with Array Processing
- 21 Case Study: Performance Comparison of Heap-Organized versus Index-Organized Tables
- 22 Case Study: SQL Tuning: “IN” versus “OR” versus Global Temporary Table
- 23 Case Study: Data Access Paths (Double Buffering)
- 24 Case Study: Covering Index
- 25 Case Study: Cursor Sharing
- 26 Case Study: Bulk Transactions
- 27 Case Study: Missing Statistics
- 28 Case Study: Misconfigured SAN Storage
APPENDICES
- Appendix A Oracle Product Documentations
- A.1 Oracle Database Concepts
- A.2 Oracle Database Administrator’s Guide
- A.3 Oracle Database Reference
- A.4 Oracle Database Performance Tuning Guide
- A.5 Oracle Database 2 Day þ Performance Tuning Guide
- A.6 Oracle Database 2 Day DBA
- A.7 Oracle Database SQL Language Reference
- A.8 Oracle Database Sample Schemas
- A.9 Oracle Database PL/SQL Packages and Types Reference
- A.10 Oracle Database PL/SQL Language Reference
- A.11 Oracle Database JDBC Developer’s Guide and References
- Appendix B Using Sqlplus With Oracle
- B.1 Installation
- B.2 SQLPlus and tnsnames.ora File
- B.3 Basics of SQLPlus
- B.4 Common SQLPlus Commands
- B.5 Using SQLPlus to Execute SQL Statements
- B.6 Using SQLPlus to Execute PL/SQL Blocks 0
- B.7 Using SQLPlus Autotrace to Obtain EXECUTION PLANs and Optimizer Statistics
- B.8 Using SQLPlus Timing Command
- B.9 Exporting/Importing Oracle Databases with SQLPlus
- B.10 Creating AWR Reports with SQLPlus
- B.11 Checking Tablespace Usage with SQLPlus
- B.12 Creating EM DBConsole with SQLPlus
- Appendix C A Complete List Of All Wait Events In Oracle 11G
- Appendix D A Complete List Of All Metrics With The V$Statname View
- Appendix E A Complete List Of All Statistics With The V$Sysstat View
Index
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.
About the Authors
- Henry H. Liu, PhD, is a Software Developer at BMC Software, Inc., with a physicist background from his prior career. His primary responsibilities at BMC include helping build performance and scalability into BMC's cloud computing and enterprise service management software products. Dr. Liu is the author of the highly acclaimed Software Performance and Scalability: A Quantitative Approach (Wiley).
Book Details
- Hardcover: 728 pages
- Publisher: Wiley-IEEE Computer Society Pr; 1 edition (November 22, 2011)
- Language: English
- ISBN-10: 111805699X
- ISBN-13: 978-1118056998
- Product Dimensions: 9.2 x 6.5 x 1.7 inches
List Price: $94.95