Książki

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