Secret Oracle - Unleashing the Full Potential of the Oracle DBMS by Leveraging Undocumented Features

Front Cover
Lulu.com, 2008 - Computers - 404 pages
Secret ORACLE is the definitive guide to undocumented and partially documented features of the ORACLE database server. This book will improve your efficiency as an ORACLE database administrator and enable you to master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Topics covered include: The MERITS performance optimization method, which extends the state-of-the-art wait event tuning paradigm. Controlling processes of an ORACLE instance with the fragmentarily documented ORADEBUG command to trace SQL statements as well as wait events and dump process state, call stack, and hang analysis information. Tracing the cost based optimizer to understand its cost calculations and decisions. Understanding hidden parameters that govern Automatic PGA Memory Management. Leveraging undocumented features of the Oracle10g/11g scheduler and other partially or fully undocumented PL/SQL packages, such as DBMS_SYSTEM, DBMS_SUPPORT, and DBMS_UTILITY.
 

Contents

Introduction
9
Partially Documented Parameters
19
Hidden Initialization Parameters
37
Introduction to Data Dictionary Base Tables
47
Introduction to X Fixed Tables
89
XBH and Latch Contention
98
XKSLED and Enhanced Session Wait Data
104
SQL Statements
117
Application Instrumentation and End to End Tracing
207
Extended SQL Trace File Format Reference
223
Statspack
249
Integrating Extended SQL Trace and AWR
274
The MERITS Performance Optimization Method
294
TNS Listener IP Address Binding and IPFIRST
317
TNS Listener TCPIP Valid Node Checking
325
Real Application Clusters
337

DBMS_BACKUP_RESTORE
143
DBMS_IJOB
150
DBMS_SCHEDULER
156
DBMS_SYSTEM
167
DBMS_UTILITY
179
Oracle
187
OERR
359
ORADEBUG SQLPlus Command
373
Appendix A Glossary
385
Bibliography
391
Copyright

Common terms and phrases

Bibliographic information