Secret Oracle - Unleashing the Full Potential of the Oracle DBMS by Leveraging Undocumented FeaturesSecret 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 |
Common terms and phrases
action ALTER application backup BEGIN block cache changed Chapter client cluster column command completed connect contains contention created cursor database DBMS default dictionary disk documented dump elapsed enabled entries environment error example EXEC execution failed FETCH format function hash identifier includes instance join latch Listener lock memory module object operating option Oracle Oracle10g Oracle9i ORADEBUG package parameter PARSE password path performance Perl PL/SQL privileges procedure query Release resource response result retrieve RMAN schema script seconds SELECT server service name session shared single snapshot SQL statements SQL trace file SQL*Net SQL*Plus statistics Statspack status string trace file true undocumented UNIX variable wait events Windows write