Troubleshooting Oracle performance /
A systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c. What you'll...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress,
2014.
|
Edición: | Second edition. |
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Sumario: | A systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c. What you'll learn: Systematically identify performance problems; Configure the query optimizer to meet performance goals; Read and recognize inefficient execution plans; Minimize the impact of parsing upon performance; Optimize data access, joins, and the physical design of your database; Improve performance through parallel processing, materialized views, and result caching; Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines; Reduce inefficiencies from too much procedural code. Who this book is for: application developers and database administrators involved in troubleshooting performance problems in Oracle-based applications. -- |
---|---|
Descripción Física: | 1 online resource (xxix, 585 pages) : illustrations |
Bibliografía: | Includes bibliographical references and index. |
ISBN: | 9781430257592 1430257598 |