Skip to main content
SpringerLink
Log in
Apress

Oracle Database 12c Performance Tuning Recipes

A Problem-Solution Approach

  • Book
  • © 2013

Overview

Authors:
  1. Sam R. Alapati
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Darl Kuhn
    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Bill Padfield
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Oracle Database 12c Performance Tuning Recipes delivers proven solutions to Oracle Database administrators grappling with vexing performance problems.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 79.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 99.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-li
    Download chapter PDF

  2. Optimizing Table Performance

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 1-49

  3. Choosing and Optimizing Indexes

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 51-93

  4. Optimizing Instance Memory

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 95-124

  5. Monitoring System Performance

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 125-156

  6. Minimizing System Contention

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 157-191

  7. Analyzing Operating System Performance

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 193-215

  8. Troubleshooting the Database

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 217-258

  9. Creating Efficient SQL

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 259-305

  10. Manually Tuning SQL

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 307-334

  11. Tracing SQL Execution

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 335-373

  12. Automated SQL Tuning

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 375-414

  13. Execution Plan Optimization and Consistency

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 415-455

  14. Configuring the Optimizer

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 457-500

  15. Implementing Query Hints

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 501-535

  16. Executing SQL in Parallel

    • Sam R. Alapati, Darl Kuhn, Bill Padfield
    Pages 537-568

  17. Back Matter

    Pages 569-581
    Download chapter PDF
Back to top

About this book

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers.

Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.

  • Provides proven solutions to real-life Oracle performance problems
  • Offers relevant background and theory to support each solution
  • Gets straight to the point for when you're under pressure for results

About the authors

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Bibliographic Information

  • Book Title: Oracle Database 12c Performance Tuning Recipes

  • Book Subtitle: A Problem-Solution Approach

  • Authors: Sam R. Alapati, Darl Kuhn, Bill Padfield

  • DOI: https://doi.org/10.1007/978-1-4302-6188-9

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Sam Alapati and Darl Kuhn and Bill Padfield 2013

  • Softcover ISBN: 978-1-4302-6187-2Published: 18 December 2013

  • eBook ISBN: 978-1-4302-6188-9Published: 21 January 2014

  • Edition Number: 1

  • Number of Pages: LVII, 636

  • Number of Illustrations: 29 b/w illustrations

  • Topics: Database Management

Publish with us

Policies and ethics

Back to top

Search

Navigation