Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader, Oradebug, Dbverify, Tkprof and More (Oracle In-Focus series) (Paperback)

by Dave Moore (Author), Don Burleson (Editor) "Three languages are employed throughout this book to provide useful scripts.]..." (more)
Key Phrases: orastack utility, oerr utility, wrap utility, Trace Analyzer, Total Pages Processed, Oracle Internet Directory (more...)

Editorial Reviews

Product Description
Targeted at seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases, this book provides help on how to use the utilities provided with the Oracle database. Explained are secrets for database migration with export/import and SQL*Loader utilities as well as OS utilities such as dbverify, orastack, and orakill. Tuning utilities including tkprof and dbms_debug are described in detail in addition to monitoring utilities including dbms_alert and dbms_xplan. Also covered in the book are network and developer utilities.

About the Author
Dave Moore is a product architect at BMC Software, a leading supplier of database software tools. As the inventor of BMC's DBXray product, he has developed many products that assist Oracle DBAs and Developers. He has experience as a developer specializing in Oracle, Java and PL/SQL. He has presented at Oracle OpenWorld and is a frequent contributor to Oracle Professional and DBAZine.com.

Product Details

• Paperback: 288 pages
• Publisher: Rampant Techpress; 1 edition (August 1, 2003)
• Language: English
• ISBN-10: 0972751351
• ISBN-13: 978-0972751353
• Product Dimensions: 8.9 x 6 x 0.7 inches
• Shipping Weight: 15.5 ounces (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (18 customer reviews)
• Amazon.com Sales Rank: #836,776 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #38 in	Books > Computers & Internet > Databases > Oracle > SQL
  #76 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

2.0 out of 5 stars Limited value to a DBA, June 23, 2004

By A Customer

Hopefully pl/sql or Java developers could find something in this book, but as an Oracle DBA I am very disappointed.
This book has a misleading title and does not tell much about the real database utilities.

"Includes Oracle 9i" says the book cover. Well, it is true only if one believes that nine lines of an elementary description are sufficient for learning new 9i feature like External Table. At the same time, an old "utility" - "oerr" - deserved almost seven pages. For the Utilities such as Export, Import, SQ*Loader, and DBV this book simply lists the available parameters (options)... The book cover did not tell us how basic all this was going to be!

To summarize, Oracle "seasoned professionals" who read documentation will hardly find new tricks in this book.
Title and cover pages of professional publications should better reflect the contents and depth of the material, and correctly describe the target audience.

9 of 9 people found the following review helpful:

2.0 out of 5 stars Where are the details?, December 19, 2004

By	Jaewoo Kim (Santa Monica, CA) - See all my reviews (REAL NAME)

The utilities explained in this book lack details. Which is a critical flaw for a book professesing to explain utilities. Virtually every utility explained in this book had to be researched further by me in the internet to gain a better understanding of when and how to use it, which, of course, defeated the purpose of me paying good money for this book.

One exception, TKPROF is explained beautifully and in detail. Otherwise, the real value of this book is the author's list of Oracle's most useful utilities.

1 of 1 people found the following review helpful:

5.0 out of 5 stars My favorite quick reference for Oracle DBA projects, January 15, 2007

By	Benjamin S. Prusinski "real dba" (san diego, ca) - See all my reviews (REAL NAME)

I found this book to be a gold chest of useful tips and tricks to using the dozens of Oracle utilities and I even learned many new Oracle utilities that I had never used before that existed! It is great tool for when you need to perform an Oracle DBA task quickly and may not recall the exact syntax or method to use a particular utility such as export and import. Highly recommended!