The Art and Science of Oracle Performance Tuning - Christopher Lawson

The Art and Science of Oracle Performance Tuning

Buch | Softcover
480 Seiten
2003 | Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-59059-199-4 (ISBN)
36,37 inkl. MwSt
It is more than tweaking parameters, or following a set prescription – it involves matching application-specific knowledge with what's happening inside the database.

Based on the Lawson’s long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance.
Complete and approachable guide to tuning best practice. For novice to intermediate Oracle DBAs and developers.


Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription – it involves matching application-specific knowledge with what's happening inside the database.





Based on the Lawson’s long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.

Christopher Lawson is an independent consultant who specializes in performance tuning of data warehouse and financial applications. His articles on database management and performance tuning have appeared in numerous technical journals, and he is a frequent speaker at Oracle conferences. When he isn't tracking down elusive performance problems, Chris teaches courses on enterprise database systems for the University of Phoenix. He is also editor of the online magazine The Oracle Magician, available at www.OracleMagician.com. Chris earned his bachelor's degree and master's in business administration at the University of California, Irvine.

The Challenge of Performance Tuning; Why Many Tuning Strategies Fail; The Oracle Physician; Dealing with Humans; The Oracle Detective; Gathering More Clues; The Oracle Pathologist; Analyzing SQL Bottlenecks; Analyzing SQL Joins; The Pathologist's Toolkit: Other Tactics; The Oracle Artist; The Artist's Palette: More on Devising Solutions; The Oracle Magician; Case Studies; Appendix A: Useful V$ View Definitions.

Zusatzinfo XII, 480 p.
Verlagsort Berkley
Sprache englisch
Maße 191 x 229 mm
Themenwelt Informatik Datenbanken Oracle
Mathematik / Informatik Informatik Software Entwicklung
ISBN-10 1-59059-199-2 / 1590591992
ISBN-13 978-1-59059-199-4 / 9781590591994
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Das umfassende Praxis-Handbuch

von Lutz Fröhlich

Buch | Hardcover (2021)
MITP (Verlag)
29,99
building resilient database solutions for continuous operation

von Stephen Morris

Buch | Softcover (2023)
O'Reilly Media (Verlag)
79,80