from the Bay Area of California says:
This was very enjoyable read and
I'm very happy to see that many
of the details about using the Oracle9i dynamic SGA are revealed. The
has always been that the Oracle documentation tells you about the new
yet fail to tell you about how to apply them. After
reading this book I was able to understand the
automatic-tuning methods in Oracle10g and they made sense because the
author revealed some of the mechanisms that they use. The online
are very nice also, with many I had never seen before.
Rod Fredette, Sr.
Database Administrator, Albertsons, Inc. says:
This has been the most enlightening book I have ever read. The concise
nature of the text gives me the chance to consume a large amount of new
information in much less time. Thank you ...
Mozahid Rabbani says:
Creating a Self Tuning Oracle Database' is a great book
that helped me a lot.
reader from England says:
I was very impressed by the Plain English
renditions in this book. It is
high structured and well organized with scripts to illustrate each
is very useful for multiple blocks in Oracle9i and concise and
More Reader Comments:
Just wanted to say that Don's
book "Creating a
Self-Tuning Oracle Database" is, without any doubt, the most important
Oracle book I have ever bought!!!!
It's just a fantastic book! For me, it's not just the great scripts,
the easy-to-understand style, or the handy code deport that make this
book so marvellous, but that it has inspired me to roll up my sleeves
and dig into the database, so to speak, and find stuff out for myself.
This book is worth its weight in gold!
Page 1: Misleading use of malloc() statement:
When an Oracle database is started, the Oracle executable issues the
malloc( ) command to create a region of RAM memory. The SGA is commonly
called the Oracle region because it is a region of RAM memory on the
database server RAM heap.
When an Oracle database is started, Oracle allocates a region of RAM
memory called the System Global Area (SGA). The SGA is commonly called the
Oracle “region” because it is a region of RAM memory on the database server
RAM heap used for caching of data, SQL and miscellaneous other functions.
Page 11: Incorrect Bullet List:
The sort_area_size and hash_area_size parameters are incorrectly listed
in the SGA parameter list.
If you are not using the pga_aggregate_target
feature or multi-threaded server, then Oracle will allocate space in the
Program Global Area (PGA) using these parameters:
sort_area_size - This parameter determines the
memory region that is allocated for in-memory sorting. When the
stats$sysstat value sorts (disk) becomes excessive, you may want to
allocate additional memory.
hash_area_size - This parameter
determines the memory region reserved for hash joins. Starting with
Oracle9i, Oracle Corporation does not recommend using hash_area_size
unless the instance is configured with the shared server option. Oracle
recommends that you enable automatic sizing of SQL work areas by setting
pga_aggregate_target and hash_area_size is retained only for backward
Page 14: version-specific clarification:
Prior to Oracle9i, the KEEP and RECYCLE pools were a
sub-set of the DEFAULT pool. The DEFAULT pool is created by the
db_cache_size parameter in Oracle9i, while former versions use the
db_block_buffers parameter. Starting with Oracle9i, the KEEP and RECYCLE
pools are allocated in addition to the db_cache_size. Also, note that
Oracle9i allows the use of multiple block regions, ranging in size from
2K-32K, each with its own distinct buffer cache.
Page 78: Version-specific statement clarification:
Note: The KEEP and RECYCLE pools were a sub-pool of
db_block_buffers in Oracle8i, but starting with Oracle9i Database
db_keep_cache_size and db_recycle_cache_size became a separate
RAM area from db_cache_size.