ISBN 0-9727513-5-1 ISBN 13 978-0972751353 Library of Congress Number: 2003105335 260 pages: Perfect Bind 9x7 PD 603 Shelving: Databases/Oracle Oracle In-Focus Series # 6

Oracle Utilities Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More by Dave Moore Retail Price $27.95 / £17.95 Order now and get immediate online access to the code depot! Only $19.95 (30% off) Key Features About the Author Table of Contents Index Reader Comments

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.

* 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 dbms_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

Index Topics: $ $ORACLE_HOME @ @PRIOR_VERSION A Alert.java allsql.sql alter system kill session ANALYZE ANALYZE TABLE autotrace awk B bindsize C cdf check_object collect.dat CONNECT INTERNAL ConnectionTest.java controlfile.sql copycommit coraenv corrupt_count CurrentSessions.java D db_block_checking dba_objects dbhome dbms_alert dbms_alert_info dbms_debug dbms_profiler dbms_repair dbms_xplan dbshut dbstart dbstop dbv.cmd dbv.ksh dbverify dcf dircmp dropjava dump_orphan_keys E EXCLUSIVE execnt execpu execu exedsk exeela exemis exeqry exerow exp exp_full_database Explain Plan export utility F facility.lis fchcnt fchcpu fchcu fchdsk fchela fchqry fchrow fdf_file fix_corrupt_blocks fix_count fromuser G get_value give_raise H Hidden utility I import utility init.ora K kill L loadjava loadpsp Logontrigger.sql lsnrctl M max_users maxmem mod_plsql My_trace_file.sql O oemctl utility oerr utility oerr.bat oerr.java omsconfig.properties oracle Oracle Trace oracle_trace_collection_path oracle_trace_enable oraclec oracled oraclee oraclesm oradebug oradebug unlimit oradim oraenv oraenv_ask orakill orapwd orastack oratab ORCL92_ora_3064.trc otcrep otrace_format_file otrace_input_file otrace_stop_file otrccl otrccol otrccref otrcfmt otrcref otrcrep otrcsyn.sql owa_util   P ping plsql_profiler_data process.dat profiler_line_source.sql profiler_runs.sql profiler_top10_lines.sql profload.sql prscnt prscpu prscu prsdsk prsela prsmis R rebuild_freelists RECORDLENGTH reg_id regid.dat resumable_name resumable_timeout S serial# set_value SHARED shutmode shuttype sid sort_area_size spid SQL*Loader SQL*Net SQL*Plus COPY sqlj.exe sqlldr sqlplus start_profiler start_trace.sql starttype startup statspack sys.dbms_profiler_lib SYSDBA SYSOPER T TechNet tkprof tkprof.sql tnslsnr.exe tnsnames.ora tnsping TOID traceroute tracert transport_tablespace trc_directory trc_file TRCA$ trcanlzr trcasst trcroute U UNIX Commands kill –9 ps unrecoverable user_dump_dest Users_Trace_Files.sql usrpwd Util_Sessions.sqlj Utility Utility Locations utl_smtp V v$datafile v$datafile.db_block_size v$parameter v$process v$session v$session_wait v$sql_plan v$sql_plan_statistics v$sql_plan_statistics_all W waitany waitone wrap Reader Comments: Carol from Westport, CT says: This book has provided invaluable help in giving clear, comprehensive advise for using the utilities of the Oracle database efficiently. I am indebted to Mr. Moore for his clear writing and practical, step-by-step directions. He has really found a niche that needed to be filled and did it in a most professional way. I would recommend this book to all those who work with this system and who are just feeling their way through some very complicated procedures. Take my word- this book will pay for itself many times over. Christopher from Blackhawk, CA says: 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.

For more information, please visit this products webpage.

This product was added to our catalog on Sunday 13 April, 2003.

Customers who bought this product also purchased Oracle Debugging Exploring Oracle Internals For Just $4.00 More get a copy of "Words of the Day"! Oracle 11g New Features Oracle Tuning: The Definitive Reference Second Edition Oracle Grid & Real Application Clusters