Secrets of the Oracle Database (Expert's Voice in Oracle)

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

1. Partially Documented Parameters
2. Hidden Initialization Parameters
3. Introduction to Data Dictionary Base Tables
4. IND$, V$OBJECT_USAGE, and Index Monitoring
5. Event 10027 and Deadlock Diagnosis
6. Event 10046 and Extended SQL Trace
7. Event 10053 and the Cost Based Optimizer
8. Event 10079 and Oracle Net Packet Contents
9. Introduction to X$ Fixed Tables
10. X$BH and Latch Contention
11. X$KSLED and Enhanced Session Wait Data
12. X$KFFXP and ASM Metadata
13. ALTER SESSION/SYSTEM SET EVENTS
14. ALTER SESSION SET CURRENT_SCHEMA
15. ALTER USER IDENTIFIED BY VALUES
16. SELECT FOR UPDATE SKIP LOCKED
17. DBMS_BACKUP_RESTORE
18. DBMS_IJOB
19. DBMS_SCHEDULER
20. DBMS_SYSTEM
21. DBMS_UTILITY
22. Perl DBI and DBD::Oracle
23. Application Instrumentation and End-to-End Tracing
24. Extended SQL Trace File Format Reference
25. Statspack
26. Integrating Extended SQL Trace and AWR
27. ESQLTRCPROF Extended SQL Trace Profiler
28. The MERITS Performance Optimization Method
29. TNS Listener IP Address Binding and IP=FIRST
30. TNS Listener TCP/IP Valid Node Checking
31. Local Naming Parameter ENABLE=BROKEN
32. Default Host Name in Oracle Net Configurations
33. Session Disconnection, Load Rebalancing, and TAF
34. Removing the RAC Option Without Reinstalling
35. OERR
36. Recovery Manager Pipe Interface
37. ORADEBUG SQL*Plus Command