About the Authors:

Bert Scalzo

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 Burleson

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. Donald Burleson's books   Donald Burleson articles   Donald Burleson comments   Don Burleson blog   Free Oracle Tips HTML Text

Steve Callan

Steve Callan is an Oracle certified professional with over 20 years of progressive hands-on technical experience and nearly a decade managing mission-critical Oracle databases.  He is also a Microsoft Certified Professional (MCP), and is proficient in SQL Server 2005.  Steve has a Masters degree in Software and Information Systems from Regis University, and a Masters degree in Industrial Engineering from New Mexico State University.  He has also completed all Ph.D. coursework for his pending doctorate in Mathematical & Computer Sciences at the Colorado School of Mines. A former senior U.S. Military officer, Steve is a graduate of the prestigious United States Military Academy at West Point, earning his wings as an attack helicopter pilot.  He has over 1,000 hours of operational aviation unit experience with Apache and Cobra attack choppers and won an Army senior aviator award for his piloting skills. Steve lives in the Denver area and spends his spare time trying new wines, playing with computers, and writing a science fiction novel.

Table of Contents:
 

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 Conclusion 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 Index About Bert Scalzo About Donald K. Burleson About Steve Callan About Mike Reed About Jeff Smith