Written by one of the world's most widely-read DBAs and architect of the famous DBXray(tm) product by BMC Software, Dave Moore targets his substantial knowledge of Oracle internals at the Oracle supplied utilities. Intended for Senior Oracle professionals, these powerful utilities are hidden deep inside Oracle and Dave Moore can show you how to unleash the hidden power of these Oracle utilities.

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.

Deep inside the operating system executables there are many utilities are at the fingertips of Oracle professionals, but until now, there has been no advice on how to use these utilities. From tnsping.exe to dbv.exe to wrap.exe, Dave Moore describes each utility and has working examples in the online code depot. Your time savings from a single script is worth the price of this great book.

This book is not for beginners.  Targeted at senior Oracle DBAs and developers, this book should only be purchased by seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases.

Key Features:

• Shows numerous undocumented utilities for Oracle experts.
• Provides advanced Oracle DBA utilities tricks.
• Explains secrets for database migration with export/import and SQL Loader utilities.
• Explores OS utilities such as dbverify, orastack and maxmem.
• Presents tuning utilities including tkprof and dbms_profiler.
• Explains monitoring utilities including dbms_alert, dbverify, dbms_xplan.
• Discusses utilities for developers including wrap, sqlj, dbms_debug and loadjava.
• Describes Network utilities including tnsping, trcroute and tnslsnr.

About the Author:

Dave Moore

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.

Table of Contents:
 

Chapter 1 - Scripts Used in this Book   Environment Setup and Configuration             Database and Platforms             Java JBDC Driver   Chapter 2 - Oracle Utilities Defined   Definition of a Utility What is a Utility? Utility Locations             Methods of Discovery             Package Discovery             Binary Discovery             Other Things worth Discovering Package Utilities UNIX Utilities and Shell Scripts Windows Executables     Chapter 3 - Utilities for General Administration   Terminating Threads with orakill             Tips for Using orakill Viewing Errors with the oerr Utility             How oerr Works             oerr on Windows             Creating Custom Message Files             oerr Alternatives Memory Utilities Utilities for Starting and Stopping Databases             Auto Start on HP-UX and Solaris             Auto Start on AIX Starting and Stopping on Windows oraenv and coraenv Utilities Using orapwd to Connect Remotely as SYSDBA     Chapter 4 - Data Copy Utilities Export             Export Modes             Export Options             Parameter Files             Export Data Subsets             Maximizing Export Performance Import Options             Maximizing the Import Performance             The SQL*Plus copy Utility SQL*Loader             The Control File             The Log File             SQL*Loader Options             Maximizing SQL*Loader Performance             External Tables in 9i   Chapter 5 - Monitoring and Tuning   The dbms_alert Utility             How It Works             The dbms_alert_info Table             dbms_alert Methods             Practical Uses for dbms_alert The utl_smtp Utility The OEMCTL Utility             OMS Event Handlers             Modifying the Event Handler The dbme_xplan Utility The dbv Utility (Database Verify)             dbv Command Line Options             Executing dbv and Interpreting the Output             Executing dbv Against a Particular Segment             Automating dbv             Alternative Block Checking Mechanisms             Handling Corruption The dbms_repair Utility             Configuring the Environment                         Finding Corrupt Blocks             Repairing Corrupt Blocks             Rebuilding Freelists

Chapter 6 - Tracing Utilities   Formatting Trace Files with tkprof             Why, When tkprof?             Analyzing tkprof Results                   tkprof Command Line Options             Best Practices for Using tkprof Simple Tracing with autotrace Low Level tracing with oradebug             ORADEBUG Session tace’             ORADEBUG Dumps The Oracle Trace Utility             Starting Oracle Trace             Stopping Oracle Trace             Reporting Tracing Results             Loading Trace Data into the Database             Deleting Trace Data Trace Analyzer             How It Works             Executing Trace Analyzer             Better than tkprof?   Chapter 7 - Networking Utilities   Managing Listeners with lsnrctl Testing Connectivity Tracing Listener Connections Tracking Networks paths and Performance Chapter 8 - Utilities for Oracle Developers   PL/SQL Wrap Utility for Encryption             Best Practices for Using Wrap The dbms_profiler Utility             Installation             Starting a Profiling Session             Stopping a Profiling Session             Working with Captured Profiler Data             Useful Scripts             Best Practices for Using DBMS_PROFILER The dbms_debug Utility             Initializing a debug Session             Setting a Breakpoint             Synchronizing             Viewing and Modifying Variables The SQLJ Utility             Conclusion Loading and Dropping Java Objects Loading PL/SQL Server Pages             Executing the PSP from SQL*Plus             Executing the PSP through the Browser             Loadpsp command Line Options