Oracle SQL tuning with Oracle SQLTXPLAIN /

Mostrar otras versiones (1)

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge l...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Charalambides, Stelios
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : New York : Apress ; Distributed to the Book trade worldwide by Springer, ©2013.
Colección:Expert's voice in Oracle.
Temas:
Oracle (Computer file)
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données > Gestion.
COMPUTERS > Data Processing.
Database management
Computer science.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Introduction to SQLTXPLAIN
  • The Cost-Based Optimizer Environment
  • How Object Statistics Can Make Your Execution Plan Wrong
  • How Skewness Can Make Your Execution Times Variable
  • Troubleshooting Query Transformations
  • Forcing Execution Plans Through Profiles
  • Adaptive Cursor Sharing
  • Dynamic Sampling and Cardinality Feedback
  • Using SQLTXPLAIN with Data Guard Physical Standby Databases
  • Comparing Execution Plans
  • Building Good Test Cases
  • Using XPLORE to Investigate Unexpected Plan Changes
  • Trace Files, TRCANLZR and Modifying SQLT behavior
  • Running a Health Check
  • The Final Word.

Ejemplares similares