Oracle9i
has become one of the world’s most complex databases, and this
book is for the senior Oracle DBA who needs to automate the
complex mechanisms that govern the RAM memory regions of any
Oracle database.
The
dynamic memory features of Oracle9i make it possible to create a
self-tuning database. This exciting 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.
Focusing
on proactive tuning and scripting, this books show you how to
collect historical data and use it to develop signatures for all
memory areas. Using these metrics, you can develop scripts that
will anticipate and correct upcoming SGA performance problems.
Key
Features:
Presents a method for
monitoring important SGA metrics over long time periods.
Lists the commands to
modify the Oracle9i SGA areas, including pga_aggregate_target,
shared_pool and db_cache_size.
Describes how to recognize
patterns in RAM usage.
Explores the use of the
free STATSPACK utility to monitor and collect SGA information.
Offers sample scripts for
automating SGA tuning.
Provides access to an online code deport, full of interesting
Oracle scripts.
Furnishes tricks
for using Oracle9i RAC Cluster Guard
About the Author:
Don Burleson is one of the
world’s top Oracle Database experts with more than 20 years of
full-time DBA experience. He specializes in creating database
architectures for very large online databases and he has
worked with some of the world’s most powerful and complex
systems. A former Adjunct Professor, Don Burleson has
written 32 books, published more than 100 articles in National
Magazines, and serves as Editor-in-Chief of Oracle Internals.
Don is a popular lecturer and teacher and is a frequent
speaker at Oracle Openworld and other international database
conferences.
Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544
