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 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 DBAs to perform advanced diagnostics.  

Bert Scalzo is a Database Expert for Quest Software and a member of the TOAD dev team. He has worked with Oracle databases for well over two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and an extensive academic background - including a BS and MS in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.
Mr. Scalzo is accomplished speaker and has presented at numerous Oracle conferences and user groups - including OOW, ODTUG, IOUG, OAUG, RMOUG and many others. His key areas of DBA interest are Data Modeling, Database Benchmarking, Database Tuning & Optimization, "Star Schema" Data Warehouses, Linux and VMware.

 Mr. Scalzo has written numerous articles, papers and blogs - including for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, Ask Toad and Toad World.

 Mr. Scalzo has also written six books: Oracle DBA Guide to Data Warehousing and Star Schemas, TOAD Handbook, TOAD Pocket Reference (2nd Ed),Database Benchmarking: Practical Methods for Oracle & SQL Server, Advanced Oracle Utilities: The Definitive Reference and Oracle on VMware: Expert Tips for Database Virtualization.

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 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 more than 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.

Using the Online Code Depot Conventions Used in this Book Acknowledgements

Chapter 1: Introduction to Oracle Utilities Introduction Definition of a Utility What is a Hidden Utility? Utility Locations

Methods of Discovery Package Discovery Package Utilities

UNIX Utilities and Shell Scripts Windows Executables Conclusion
Chapter 2: UNIX/Linux Oracle OS Utilities Finding the OS Utilities in Linux/UNIX Binary Discovery UNIX/Linux Utilities for the Oracle Professional Introduction to the UNIX Architecture Dialects of UNIX UNIX Access Control Management UNIX and DOS Commands Introduction to UNIX Utilities Appending Data to UNIX Files Redirecting Output to a NULL Device Common Oracle UNIX Commands File Management in UNIX Directory Management in UNIX The Oracle environment in UNIX Dissecting Complex UNIX commands Deciphering a Complex UNIX Command

Conclusion

Chapter 3: Windows Oracle OS Utilities

Reasons for Using Oracle on Windows Windows Utilities for Monitoring Oracle

Checking Windows Services for Oracle Test the Windows Oracle Service

Oracle Scripts for Windows Sample Invocation of Oracle from Windows Running a Data Pump Export from Windows Sending Oracle Output via Windows Email Monitoring Trace and Dump Files in Windows Starting and Stopping Oracle on Windows

Conclusion

Chapter 4: Oracle Utilities for Server-Side Functions

Server Management Database Creation and the DBCA SQL*NET Configuration Files: NETCA

External Functions Auto Start and Auto Stop lsnrctl emca emctl relink External job scheduling Using the OPatch Utility Utilities for Analyzing Oracle Trace Files Using the Trace Analyzer Utility

Remote Connection Management Using orapwd

Server Monitoring Utilities Using vmstat Server RAM and Oracle

Tracking External Server Metrics with AWR Enterprise Manager for Server & Environment Using AWR and STATSPACK for Server Monitoring Vmstat to the Rescue Using the ltom utility

File analysis Using the BBED Block Editor Utility Using and Linking BBED

File Analysis The DBV Utility (Database Verify)

dbv

The dbms_repair Utility Configuring the Environment Finding Corrupt Blocks Repairing Corrupt Blocks Rebuilding Freelists

Process Management kill orakill renice trcsess TKPROF

Using the Orastack Utility

RAC Management VIPCA crsctl crs_start crs_stop crs_stat srvctl

Storage Management ocfs2console mkfs.ocfs2 tunefs.ocfs2 fsck.ocfs2 mounted.ocfs2 asmtool asmtoolg asmcmd

Chapter 5: Oracle SQL Management Utilities

Introduction
SQL Utilities SQL*Plus SQL Developer Toad for Oracle^® Advanced SQL Techniques Login Scripts Dynamic SQL Scripting SET TIMING ON TIMING START & STOP Obtaining Explain Plans SQL*Plus AUTOTRACE Interpreting Explain Plans

Conclusion

Chapter 6: Oracle DBA Utilities

Introduction

Reorganization Utilities Data Pump (EXPDP) Export Transportable Tablespaces IMPDP Import Transportable Tablespaces Import Partition Options Import Remapping Options DBMS_REDEFINITION DBMS_METADATA Recovery Utilities DBMS_FLASHBACK DBMS_LOGMNR

Job Scheduling DBMS_JOBS DBMS_SCHEDULER

Access Security DBMS_RLS

File Security DBMS_CRYPTO DBMS_OBFUSCATION_TOOLKIT UTL_COMPRESS UTL_ENCODE

Replication DBMS_AQADM DBMS_AQ DBMS_REPUTIL

Space Management DBMS_SPACE_ADMIN DBMS_SPACE

Data Corruption Utilities DBVERIFY DBMS_REPAIR

Database Session Management DBMS_SESSION

File Management DBMS_FILE_TRANSFER UTL_SMTP UTL_TCP ASMCMD

Instance Management DBMS_SHARED_POOL

Conclusion

Chapter 7: Oracle Tuning and Monitoring Utilities

Introduction

Tuning Utilities DBMS_WORKLOAD_REPOSITORY DBMS_WORKLOAD_CAPTURE DBMS_WORKLOAD_REPLAY DBMS_ADVISOR

SQL Tuning DBMS_ADVANCED_REWRITE DBMS_STATS DBMS_SQLTUNE

Monitoring DBMS_ALERT DBMS_SERVER_ALERT DBMS_WARNING DBMS_MONITOR

Conclusion

Chapter 8: Oracle Advisory and Diagnostic Utilities

Introduction

ADRCI: ADR Command Interpreter Changes in Oracle 11g ADRCI Command Line Interface

SQL Performance Analyzer Defining a Workflow

Other Utilities Advisor Central Traditional Tracing Methods

Conclusion

Chapter 9: Oracle Developer Utilities

Introduction

UTL Utilities UTL_COLL UTL_COMPRESS UTL_DBWS UTL_ENCODE UTL_FILE UTL_HTTP UTL_I18N UTL_INADDR UTL_LMS UTL_MAIL UTL_NLA UTL_RAW UTL_RECOMP UTL_REF UTL_SMTP UTL_SPADV UTL_TCP UTL_URL

XML Utilities DBMS_XMLGEN DBMS_XMLSAVE DBMS_XMLSTORE

Other Useful Utilities Oerr DBMS_PROFILER DBMS_DEBUG

Conclusion

Chapter 10: BBED: The Block Browser and Editor Tool

Introduction ROWID_INFO Procedure

Starting a Session Altering Data Undeleting a Row Corrupted Blocks Restoring Data Restoring a File

Conclusion Additional information

Chapter 11: Oracle       Job Scheduling

Introduction to Job Scheduling
Fundamentals of Job Scheduling UNIX Job Scheduling (cron) vs dbms_scheduler Job Scheduling Components

Using cron and crontab to Schedule Oracle Jobs

The crontab Options The Format of the crontab File Using the Windows Job Scheduler at.exe utility

Internal Oracle Job Scheduling Oracle Scheduler Overview

Configuring Oracle Job Scheduling Setting up a Test Environment

Overview of the dbms_scheduler Functions Programs Schedules

Creating Oracle Jobs Job Classes Oracle Job Scheduling Windows Job Scheduling Window Groups Enabling, Disabling and Setting Attributes of Scheduler Objects

Time-based Job Scheduling Setting Job Execution Dates Intervals and Interval Literals

Calendar Syntax in Oracle Job Scheduling

Complex Date Rules for Job Execution

Creating an Oracle Job Chain Conditional Job Creation Conditional Job Enabling Conditional Job Runs Using Oracle Advanced Queuing Conditional Job Runs Using a Custom Table Solution

Implementing Error Checking Routines

Sending Email Notifications of Job Errors Using UTL_SMTP Using UTL_MAIL in Oracle

Monitoring Oracle Job Execution

Killing Oracle Job Sessions Setting Job Scheduler Attributes

Job Priorities

Scheduler Logging Job Logs Displaying Job Run Details Window Logs Purging Logs

Using the Job Resource Manager

Export/Import and the Scheduler

Job Services and Instance Stickiness

Conclusion