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

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

by Donald K. Burleson
     
 

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 provides ways to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle database administrators, this guide

Overview

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 provides ways to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle database administrators, 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. 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.

Product Details

ISBN-13:
9780972751322
Publisher:
Rampant Techpress
Publication date:
08/01/2003
Series:
Oracle In-Focus series
Pages:
160
Product dimensions:
6.98(w) x 9.02(h) x 0.41(d)

Meet the Author

Donald K. Burleson is the author of 16 Oracle database books and the editor-in-chief of Oracle Internals. He is an Oracle consultant with extensive experience with designing and implementing Oracle8 databases, including systems architecture, project management, 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >