Oracle Database 12c Performance Tuning Recipes : A Problem-Solution Approach

Oracle Database 12c Performance Tuning Recipes A Problem-Solution Approach

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 manu...

Descripción completa

Detalles Bibliográficos
Autores principales: Alapati, Sam. author (author), Kuhn, Darl. author, Padfield, Bill. author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2013.
Edición:1st ed. 2013.
Colección:Expert's voice in Oracle.
Materias:
Oracle (Computer file)
Database management.
Database Management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629466206719
Tabla de Contenidos:
  • Optimizing table performance
  • Choosing and optimizing indexes
  • Optimizing instance memory
  • Monitoring system performance
  • Minimizing system contention
  • Analyzing operating system performance
  • Troubleshooting the database
  • Creating efficient SQL
  • Manually tuning SQL
  • Tracing SQL execution
  • Automated SQL tuning
  • Execution plan optimization and consistency
  • Configuring the optimizer
  • Implementing query hints
  • Executing SQL in parallel.

Ejemplares similares