- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (7) from $1.99
-
Used (7) from $1.99
Ships from: St Louis, MO
Usually ships in 1-2 business days
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
Ships from: Halethorpe, MD
Usually ships in 1-2 business days
Ships from: Ashburn, VA
Usually ships in 1-2 business days
Ships from: Fort Mill, SC
Usually ships in 1-2 business days
Ships from: Dunfermline, United Kingdom
Usually ships in 1-2 business days
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.
Anonymous
Posted Sat Oct 25 00:00:00 EDT 2003
This book is another insightful guide from the master of Oracle database tuning, Donald Burleson. Readers will no doubt recall that Mr. Burleson wrote the Oracle best sellers, 'Oracle High-Performance SQL Tuning' and Oracle High-Performance Tuning with Statspack.' Mr. Burleson brings the same level of expertise to this new series of books published by 'Rampant Techpress.' This volume unravels the mysteries of the various database caches and pools in the 9i database. Are you confused about the different pools and database caches that have been introduced in recent years? Do you know what the difference is between the 'Keep Pool' and the 'Recycle Pool' ? Okay, how about this: How many buffer caches are there-7 or 8 ? Where should you put your indexes-in the cache with the largest block size, or the smallest? I confess that I have found it difficult to keep up with the myriad cache and pool changes that Oracle has introduced in recent years. I suspect that other DBAs also find it challenging. These issues are all addressed in this book, with extensive examples and scripts, so that readers can try it for themselves. There are a total of 29 useful scripts that are provided with this book (I successfully downloaded them from the Rampant web site). I found the section, 'Internals of the Oracle Data Buffers' particular interesting. It explains the difference between the pre-Oracle 9i buffering system and the new 'touch count' method used in 9i. In this section, the script 'Buf_Blocks.sql' is really amazing. It lists in tabular format the exact distribution of objects in the data buffers, sorted by buffer pool. Using this script, you can see which pool your indexes or tables have been assigned. Beware! This book isn't filled with 'fluff' or some theoretical treatises dreamed up by academians. This is a book BY AND FOR PRACTICING DBAS. The focus in the book is on PROACTIVELY improving database performance. If you are a 'Hands on' DBA interested in getting the best performance from your system, then you will find this book very helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
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 ...