Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader, oradebug, tkprof, & More (Oracle In-Focus series)
||Author: Dave Moore, Donald K. Burleson|
List Price: $27.95
Our Price: Click to see the latest and low price
Publisher: Rampant TechPress (01 August, 2003)
Sales Rank: 4,236
Average Customer Rating: 5 out of 5
Customer ReviewsRating: 5 out of 5
A great Oracle Utility Reference/How-to
After reading "Oracle Utilities" by Mr. Moore and Burleson, I have advocated the book as a must for our project teams leveraging Oracle DBs. The book provides insights and tips that would take someone years of experience to acquire. It serves as an excellent reference and its organization makes it easy to locate the information you need. Once you find what you are looking for, the book carefully walks you through the implementation of the techniques found in the book. Our developers and software quality assurance folks have incorporated many of the techniques found in the book into our ISO-9001:2000 and SEI/CMM Level 3 automated testing and QA procedures.
The book has become one of the most utilized Oracle textbooks at the company, to the point where we have "can not leave the building" copies and traveling copies for our road warriors. The book is highly recommended.
Rating: 5 out of 5
TAKES THE MYSTERY OUT OF ORACLE UTILITIES!
This book is another in the series of technical volumes published by "Rampant Techpress," published by Don Burleson. The purpose of this book by Dave Moore is to explain to the reader the use of the various Oracle utilities. Some of these utilities are well-known, such as Tkprof; others are far more obscure-such as the Dbms_Profiler utility, or the PL/SQL Wrap Utility.
Mr. Moore succinctly illustrates how to use each utility. For example, in the section Dbms_Repair, he takes the reader through the following steps: Configuring the environment; Finding corrupt blocks; Repairing corrupt blocks, Rebuilding Freelists. Each topic includes a discussion of the purpose, as well as an example of how to accomplish the action.
One particularly interesting section is the discussion entitled "Dbms_Alert Utility." Mr. More gives a brief background on this tool, explains how it works, provides a sample Java program, provides a sample trigger test script, then shows a sample run display. Finally, he also illustrates the use of an associated database table.
As Mr. Moore explains in the Introduction, this is a PRACTICAL book-not just some theoretical treatise on approaches to performance tuning. He concisely explains the utilities that are available, with plenty of examples. I found the book easy to read, and the examples very clear.
Rating: 5 out of 5
Just What I Needed!!
This book fits a niche in my Oracle collection and has already proven useful to me in my job. Moore finally explains in concise terms what these utilities do and how to optimize them. I hope the rumor is true, that Moore is working on an even more detailed version which will also include those utilities in 10g. I'd buy that one, too.
· Oracle9i RAC: Oracle Real Application Clusters Configuration and Internals
· Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series)
· Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts (Oracle In-Focus series)
· Optimizing Oracle Performance
· Conducting the Oracle Job Interview: IT Manager's Guide for Oracle Job Interviews with Oracle Interview Questions (Oracle In-Focus series)