Oracle performance survival guide : a systematic approach to database optimization /

This complete guide to Oracle 11g Release 2 performance tuning shows how to tune performance efficiently by addressing causes rather than symptoms. It addresses all facets of performance, including application design, SQL tuning, contention management, memory physical IO, and more.

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Harrison, Guy
Format: Electronic eBook
Language:Inglés
Published: Upper Saddle River, N.J. : Pearson/Prentice Hall, ©2010.
Series:Prentice Hall professional Oracle series.
Subjects:
Oracle.
Oracle
Database management.
Databases.
Bases de données > Gestion.
SGBD = Systèmes de gestion de bases de données.
Database management
Databases
Engineering & Applied Sciences.
Computer Science.
Oracle (système informatique)
Bases de données relationnelles.
SQL (langage de programmation)
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • I. Methods, concepts, and tools. Oracle performance tuning : a methodical approach ; Oracle architecture and concepts ; Tools of the trade
  • II. Application and database design. Logical and physical database design ; Indexing and clustering ; Application design and implementation
  • III. SQL and PL/SQL tuning. Optimizing the optimizer ; Execution plan management ; Tuning table access ; Joins and subqueries ; Sorting, grouping, and set operations ; Using and tuning PL/SQL ; Parallel SQL ; DML tuning
  • IV. Minimizing contention. Lock contention ; Latch and mutex contention ; Shared memory contention
  • V. Optimizing memory. Buffer cache tuning ; Optimizing PGA memory ; Other memory management topics
  • VI. IO tuning and clustering. Disk IO tuning fundamentals ; Advanced IO techniques ; Optimizing RAC.

Similar Items