Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle database server. Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle. Table of Contents * Partially Documented Parameters * Hidden Initialization Parameters * Introduction to Data Dictionary Base Tables * IND$, V$OBJECT_USAGE, and Index Monitoring * Event 10027 and Deadlock Diagnosis * Event 10046 and Extended SQL Trace * Event 10053 and the Cost Based Optimizer * Event 10079 and Oracle Net Packet Contents * Introduction to X$ Fixed Tables * X$BH and Latch Contention * X$KSLED and Enhanced Session Wait Data * X$KFFXP and ASM Metadata * ALTER SESSION/SYSTEM SET EVENTS * ALTER SESSION SET CURRENT_SCHEMA * ALTER USER IDENTIFIED BY VALUES * SELECT FOR UPDATE SKIP LOCKED * DBMS_BACKUP_RESTORE * DBMS_IJOB * DBMS_SCHEDULER * DBMS_SYSTEM * DBMS_UTILITY * Perl DBI and DBD::Oracle * Application Instrumentation and End-to-End Tracing * Extended SQL Trace File Format Reference * Statspack * Integrating Extended SQL Trace and AWR * ESQLTRCPROF Extended SQL Trace Profiler * The MERITS Performance Optimization Method * TNS Listener IP Address Binding and IP=FIRST * TNS Listener TCP/IP Valid Node Checking * Local Naming Parameter ENABLE=BROKEN * Default Host Name in Oracle Net Configurations * Session Disconnection, Load Rebalancing, and TAF * Removing the RAC Option Without Reinstalling * OERR * Recovery Manager Pipe Interface * ORADEBUG SQL*Plus Command

Norbert Debes Oracle8、Oracle8i、Oracle9i注冊專業Oracle DBA，先後擔任Oracle德國分公司支持服務部組長、戰略聯盟技術客戶經理。從2002年開始，他一直以DBA、性能工程師、架構師等身份擔任大型公 司工業、金融、自動化、服務部門的獨立顧問。他發錶過不少關於Oracle的文章，在每年德國舉行的Oracle用戶組會議及許多商品交易會上公開宣講 Oracle技術。他與人閤著過兩本關於Oracle9i的書。