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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Harrison, Guy
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Upper Saddle River, N.J. : Pearson/Prentice Hall, ©2010.
Colección:Prentice Hall professional Oracle series.
Temas:
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)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares