ISBN 10:  0-9797951-3-3 ISBN 13: 978-0-9797951-3-8	Library of Congress Number: xxx
600 pages Hardcover - 9x7	Publication Date: Dec 2008
Shelving:  Databases/Oracle	Oracle In-focus Series #xx

Dr. Bert Scalzo, Andrew Kerber, Donald K. Burleson, Steve Callan

Retail Price $59.95 /  £44.95

Order now at 30% off and get access to the code depot!

Only $41.95 (30% off)

The authors approach Oracle Utilities from a functional perspective, adding value by explaining the "why" and "how" for the use of all Oracle Utilities.  This comprehensive book includes details on all of the Oracle utilities, including experts-only sections on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities.

This indispensable book covers all areas of Oracle database administration and includes secrets for database migration (with Data Pump and SQL*Loader) and detailed tips for using The Oracle OS utilities (e.g. BBED, dbv, orastack, orakill).  The book also covers Oracle tuning utilities, including ADDM and the SQL tuning advisors as well as the traditional command-line tuning utilities such as dbms_alert and dbms_xplan, tkprof and dbms_debug.

This book is special because noted Oracle experts supplement the operational considerations of Oracle utilities with expert insights and working scripts.  The time savings from a single utility script is easily worth the price of this definitive book.

This book is not for beginners.  These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.

• Understand how to automate database management with Oracle utilities.

• Learn about the Oracle's secret hidden utilities.

• See how to use the Oracle DBMS package utilities.

• Get working examples of all Oracle utilities on the code depot download.

• Discover the secrets used by professional DBA's to perform advanced diagnostics.
 

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Andrew Kerber

• Type of Oracle utilities (OS, packages, executables)
• Methods of finding the utilities
• Finding dbms packages
• Finding the OS utilities
• Command line vs. OEM (e.g. ADDM)

• Oracle Utility Locations

• - Oracle Utility Locations

• External functions (archived redo, job scheduling, auto start, managing OS files)
   
• Starting and Stopping instances using the auto start utilities (oraenv, coraenv) on Linux, Solaris, HP/UX, AIX, and Windows.
   
• Remote connection management (orapwd, external authentication, SYSDBA)
   
• Server monitoring (AWR external tables, ltom, vmstat extensions)
   
• File analysis (BBED, dbv, trcsess, trace analyzer)
   
• Process management (orakill)

• SQL*Plus - autotrace

• Reorg utilities (Data Pump (expdp, impdp, dbms_datapump), dbms_redefinition, dbms_metadata, nid.exe)
   
• Recovery utilities - (dbms_flashback, dbms_logmnr)
   
• Index utilities - ("validate structure", dbms_i_index_utl)
   
• Job scheduling (dbms_job, dbms_scheduler)
   
• Access security - (dbms_rls)
   
• File Security - (wrap.exe, dbms_crypto, dbms_obfuscation_toolkit, utl_compress, utl_encode)
   
• Replication (dbms_aq, dbms_aqadm, dbms_reputil)
   
• Space management - (dbms_space_admin, dbms_space)
   
• Data management (SQL*Loader)
   
• Data corruption utilities (dbverify, dbms_repair, BBED)
   
• Task management (hang manager - hangman, dbms_session)
   
• File management - (dbms_file_transfer, utl_smtp, utl_tcp, asmcmd)
   
• Instance management - (dbms_shared_pool)
   

• Tuning utilities - (dbms_workload_repository,
  dbms_advisor)
   
• SQL Tuning - (dbms_sqltune, dbms_advanced_rewrite, dbms_stats)
   
• Monitoring (ASH, dbms_alert, dbms_server_alert, dbms_warning, dbms_monitor)
   

• 11g Automatic diagnostic repository (adrci)
   
• ADDM
   
• 11g SQL Performance Advisor (SPA)
   
• Tracing utilities - (dbms_trace
   
• SQLAccess advisor
   
• SQLTuning advisor
   
• SGA Advisors - (v$db_cache_advice)
   
• Segment advisors
   
• Elapsed time performance utilities (AWR/STATSPACK utility, ASH reports)

• oerr
• dbms_profiler
• dbms_debug
• htmldb_util
• utl_dbws
• utl_i18n
• utl_lms
• utl_mail
• utl_recomp
• utl_file
• utl_http
• utl_raw
• utl_ref
• dbms_lob
• dbms_pipe
• dbms_sql
• dbms_transaction
• dbms_transform
• dbms_utility
• dbms_wm
• dbms_service
   
• XML Utilities - (dbms_xmlgen, dbms_xmlsave, dbms_xmlquery, dbms_xdbz, dbms_xmlstore)

10 - For experts only - Oracle undocumented utilities

• BBED
• oradebug