More than ever before, today's Oracle DBA faces a database farm that is growing both in physical size and actual numbers. To keep these databases up and performing at exceptional levels, the database administrator needs more than a cobbled together set of scripts that they use to (hopefully) verify that everything is in order.
Such an approach does not scale or offer the protection that critical business applications need. Instead, a DBA needs a solid methodology that can be implemented and replicated to one or thousands of databases to ensure peak availability and performance.
This book introduces both strategic and tactical methodologies that the DBA can take and utilize in a proactive manner to guarantee success in the fight for maximum availability and performance. It begins by introducing the proper ways to gauge and measure database performance, and then highlights how to put the right foundation in place for continuous database success.
It then takes the reader into the strategies that can be used to quickly take the guesswork out of knowing what databases really need attention in their organization. From there, it demonstrates how to avoid the major killers of database availability and performance by providing proven techniques that work in the real world.
Each chapter turns the spotlight on database performance and shows how to work with surgical precision to locate hidden headaches that threaten exceptional database performance.
It is my hope that this book will provide you with insight that helps your database run as faster than your most demanding user expects.