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

Dave Moore (Author), Don Burleson (Editor)

Book Description

Series: Oracle In-Focus series | Publication Date: August 1, 2003

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.

Editorial Reviews

About the Author

Dave Moore is a product architect at BMC Software and the inventor of BMC's DBXray product. He has presented at Oracle OpenWorld and is a frequent contributor to Oracle Professional and DBAZine.com. He lives in Austin, Texas. Donald K. Burleson is the author of 16 Oracle database books and is the editor in chief of Oracle Internals. He is an Oracle consultant with extensive experience 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.

Product Details

• Paperback: 288 pages
• Publisher: Rampant Techpress; 1 edition (August 1, 2003)
• Language: English
• ISBN-10: 0972751351
• ISBN-13: 978-0972751353
• Product Dimensions: 9.1 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 Best Sellers Rank: #327,875 in Books (See Top 100 in Books)
  • #32 in Books > Computers & Technology > Databases > Oracle
  • #52 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

16 of 16 people found the following review helpful:

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

By A Customer

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

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.

8 of 8 people found the following review helpful:

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

By 

Jaewoo Kim "OB-Wan" (Santa Monica, CA) - See all my reviews
(TOP 1000 REVIEWER)    (VINE VOICE)    (REAL NAME)   

Amazon Verified Purchase

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

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)   

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

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!