Overview

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.

Full Product Details

Author:   Dave Moore
Publisher:   Rampant TechPress
Imprint:   Rampant TechPress
Dimensions:   Width: 18.50cm , Height: 1.40cm , Length: 23.00cm
Weight:   0.454kg
ISBN:  

9780972751353

ISBN 10:   0972751351
Pages:   260
Publication Date:   01 April 2004
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Inactive
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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 dbme_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

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions