Apress Access

Secrets of the Oracle Database

By Norbert Debes

  • eBook Price: $41.99
Buy eBook Buy Print Book

Secrets of the Oracle Database Cover Image

Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-1952-1
  • User Level: Intermediate to Advanced
  • Publication Date: June 1, 2009
  • Available eBook Formats: PDF

Related Titles

  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Oracle Application Express Administration
  • Expert Oracle Indexing and Access Paths, 2nd Edition
  • Pro Oracle GoldenGate for the DBA
  • Relational Database Programming
  • DevOps, DBAs, and DBaaS
  • Securing SQL Server
  • Salesforce.com Lightning Process Builder and Visual Workflow
  • Database Systems
Full Description

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.

What you’ll learn

  • Take advantage of Oracle’s built–in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more.
  • Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure.
  • Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely–documented repository, and integrating with SQL Trace.
  • Take control of your instance through the ill–documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more.
  • Leverage undocumented features in Oracle’s built–in scheduler to better automate your workload.
  • Take full advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.
  • Understand just enough theoretical knowledge to know why something works in Hadoop, without getting bogged down in abstruse walls of theory.

Table of Contents

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
  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
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. The Definitive Guide to MongoDB: Third Edition


      View Book

    2. Pro SQL Server Wait Statistics


      View Book

    3. SQL Server T-SQL Recipes


      View Book

    4. Enterprise Cybersecurity


      View Book