|
Oracle Utilities
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.
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
|
