Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series)
| Author | : | |
| Rating | : | 4.82 (683 Votes) |
| Asin | : | 0972751327 |
| Format Type | : | paperback |
| Number of Pages | : | 160 Pages |
| Publish Date | : | 2014-11-10 |
| Language | : | English |
DESCRIPTION:
Burleson is the author of 16 Oracle database books and the editor-in-chief of Oracle Internals. About the AuthorDonald K. 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.
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
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.. The dynami
Jaewoo Kim said Short and Incisive. The book is everything the other reviewers have already said. The author surely knows what he is writing and the book contains lot of useful information on the inner workings of SGA and how to fine tune it.One caveat, the author deliberately leaves out the details on the STATSPACK so he can sell you an ANOTHER . Most useful for me 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 problem has always been that the Oracle documentation tells you about the new features yet fail to tell you about how to apply them.After reading this book I was able to underst. Excellent coverage on SGA internals I was very impressed by the Plain English renditions in this book. It is high structured and wekk organized with scripts to illustrate each concept. It is very useful for multiple blocks in Oracle9i and concise and informative.The only fault is that it assumes a working DBA knowledge, but the scripts help make-