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

Norbert Debes

ISBN 10: 1435705513 / ISBN 13: 9781435705517

Published by Lulu.com, US, 2007

About this Item

Seller Inventory # LU-9781435705517

Bibliographic Details

• Title: Secret Oracle -- Unleashing the Full Potential of the Oracle Dbms by Leveraging Undocumented Features
• Publisher: Lulu.com, US
• Publication Date: 2007
• Language: English
• ISBN 10: 1435705513
• ISBN 13: 9781435705517
• Binding: Paperback
• Condition: New
• Dimensions: 18.9W x 2.11H x 24.61D centimeters 18.9 centimeters width by 2.11 centimeters height by 24.61 centimeters depth
• Weight: 720 grams

About this title

Synopsis

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.