Cover Image

Oracle database performance and scalability : a quantitative approach /

Bibliographic Details
Main Author: Liu, Henry H.
Format: eBook
Language:English
Published: Hoboken, N.J. : John Wiley, 2012.
Series:Wiley online library.
Subjects:
Oracle (Computer file)
Database management.
Electronic books.
Online Access:Connect to the full text of this electronic book
Table of Contents:
  • Frontmatter
  • Introduction
  • Getting Started With Oracle. Part Introduction
  • Basic Concepts
  • Installing Oracle Software
  • Options for Accessing an Oracle Server
  • A Quick Tour of an Oracle Server
  • Oracle Architecture from Performance and Scalability Perspectives. Part Introduction
  • Understanding Oracle Architecture
  • Oracle 10g Memory Management
  • Oracle 11g Memory Management
  • Oracle Storage Structure
  • Oracle Wait Interface (OWI)
  • Oracle Data Consistency and Concurrency
  • Anatomy of an Oracle Automatic Workload Repository (AWR) Report
  • Oracle Advanced Features and Options
  • Top 10 Oracle Performance and Scalability Features
  • Oracle-Based Application Performance and Scalability by Design
  • Project: Soba₇A Secure Online Banking Application on Oracle
  • Optimizing Oracle Performance and Scalability. Part Introduction
  • Logistics of the Oracle Cost-Based Optimizer (CBO)
  • Oracle SQL Tuning
  • Oracle Indexing
  • Auto_Tune Features
  • Case Studies: Oracle Meeting Real World Performance and Scalability Challenges. Part Introduction
  • Case Study: Achieving High Throughput with Array Processing
  • Case Study: Performance Comparison of Heap-Organized Versus Index-Organized Tables
  • Case Study: SQL Tuning: ₃IN₄ Versus ₃OR₄ Versus Global Temporary Table
  • Case Study: Data Access Paths (Double Buffering)
  • Case Study: Covering Index
  • Case Study: CURSOR_SHARING
  • Case Study: Bulk Transactions
  • Case Study: Missing Statistics
  • Case Study: Misconfigured SAN Storage
  • Appendix A: Oracle Product Documentations
  • Appendix B: Using SQL*Plus with Oracle
  • 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.