Oracle has become the world's most flexible
and robust database and along with great power comes great
complexity. This complexity requires that the DBA have expert
knowledge of Oracle internals. This book provides a thorough
step-by-step approach for holistic Oracle tuning in this
challenging information technology era. It represents the
knowledge accumulated from tuning thousands of Oracle
databases. nt face="Arial">Oracle tuning has always been a complex
task; however, it has become even more complex as Oracle
evolves and yields new techniques for achieving optimal
performance in the stressed production environment of today’s
Oracle STATSPACK and AWR has
introduced a revolution in database tuning. By understanding
these time-series tables, we can develop time-series tuning
models to predict upcoming outages and dynamically change the
instance to accommodate the impending resource changes.
Database tuning efforts must become as sophisticated as the
This book strives to show you how to
leverage upon the wealth of Oracle performance information so
that you can create a robust Oracle database engine, one that
maximizes computing resources while minimizing overhead.
If you are seeking theory, this is not
the book for you. This book encapsulates the combined
knowledge of over a century of hands-on DBA tuning experience,
a pragmatic, practical approach for the professional Oracle
This is not a book for
beginners. Targeted at the senior Oracle DBA, this
comprehensive book gives you all of the knowledge you need to
be successful in tuning even the most complex Oracle database.
The code download for this book is packed with ready-to-run
scripts to monitor and identify even the most challenging
* See how to
access Oracle's time-series performance data.
secrets on how to identify performance signatures and shifting
workloads over time.
* Download the code depot for a
gold mine of ready-to-run tuning scripts.
to analyze historical trends to predict impending performance
* Get tips for understanding Oracle
elapsed-time tuning reports.
* Create customized
performance alerts to fix a problem before it impedes end-user
* See how to deploy intelligent Oracle
Understand proactive time-series Oracle tuning
* Learn secrets for
optimizing entire SQL workloads.