Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance

From the Publisher: The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle DBA's this guide focuses on proactive tuning and scripting, and shows how to collect historical data and use it to develop signatures for all memory areas. Using these metrics DBAs will be able to develop scripts that will anticipate and correct upcoming SGA performance problems. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts. About the Author: Donald K. Burleson is the author of sixteen Oracle database books and is the editor-in-chief of Oracle Internals. His is an Oracle consultant with extensive experience with designing and implementing Oracle8 databases, including systems architect, project manager, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP and tuning very large Oracle databases. He lives in Kittrell, North Carolina.