The Definitive Reference
Donald K. Burleson
Retail Price $59.95 / £44.95
|Order now at 30% off !||Only $41.95
|ISBN 10: 0-9916386-5-4 ISBN 13: 978-0-9916386-5-9||Library of Congress Number: 2014936286|
|748 pages Perfect Bind - 7.5x9.25||PD 0314|
|Shelving: Databases/Oracle||Oracle In-Focus Series #31|
This is the definitive guide to all Oracle utilities, and it is targeted at experienced Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases.
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 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.
About the Authors:
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 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.
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.
Using the Online Code Depot Conventions Used in this Book Acknowledgements
Methods of Discovery Package Discovery Package Utilities
UNIX Utilities and Shell Scripts Windows Executables Conclusion
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
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)
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 asmcmdConclusion
Chapter 5: Oracle SQL Management Utilities
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
Chapter 7: Oracle Tuning and Monitoring Utilities
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
Chapter 8: Oracle Advisory and Diagnostic Utilities
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
Chapter 9: Oracle Developer Utilities
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
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
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
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