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

by Norbert Debes

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

404 pages, Paperback

First published March 23, 2008

Reviews

[Corrado Piola · Rating 4 out of 5]

The real bible about undocumented Oracle parameters!
I was surprised about the details of the PGA internal structure in Chapter 1: the really interesting hidden parameters _PGA_MAX_SIZE, _SMM_MAX_SIZE and _SMM_PX_MAX_SIZE.
Obviously... Not for beginners!