Skip to main content
SpringerLink
Log in
Book cover
  • Book
  • © 2009

Secrets of the Oracle Database

Apress

Authors:

  1. Norbert Debes
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Exclusive – Gives readers the ability to "join the club" of those having knowledge that traditionally has only been available to those with the "right" insider contacts.

  • Authoritative – written by an expert-level Oracle professional who spent several years working as an insider for Oracle Corporation.

  • Helpful – Illuminates features that truly can be applied in production environments to help solve tough problems that Oracle administrators and developers face on a routine basis.

  • Proven – The author's work is accurate, well-tested, and proven by clear examples.

Sections

Buy it now

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (37 chapters)

  1. Front Matter

    Pages i-xxxv
    PDF

  2. Initialization Parameters

    1. Front Matter

      Pages 1-1
      PDF

    2. Partially Documented Parameters

      • Norbert Debes
      Pages 3-27

    3. Hidden Initialization Parameters

      • Norbert Debes
      Pages 29-37

  3. Data Dictionary Base Tables

    1. Front Matter

      Pages 39-39
      PDF

    3. IND$, V$OBJECT_USAGE, and Index Monitoring

      • Norbert Debes
      Pages 45-53

  4. Events

    1. Front Matter

      Pages 55-55
      PDF

    2. Event 10027 and Deadlock Diagnosis

      • Norbert Debes
      Pages 57-60

    3. Event 10046 and Extended SQL Trace

      • Norbert Debes
      Pages 61-62

    4. Event 10053 and the Cost Based Optimizer

      • Norbert Debes
      Pages 63-86

    5. Event 10079 and Oracle Net Packet Contents

      • Norbert Debes
      Pages 87-89

  5. X$ Fixed Tables

    1. Front Matter

      Pages 91-91
      PDF

    2. Introduction to X$ Fixed Tables

      • Norbert Debes
      Pages 93-104

    3. X$BH and Latch Contention

      • Norbert Debes
      Pages 105-111

    4. X$KSLED and Enhanced Session Wait Data

      • Norbert Debes
      Pages 113-118

    5. X$KFFXP and ASM Metadata

      • Norbert Debes
      Pages 119-125

  6. SQL Statements

    1. Front Matter

      Pages 127-127
      PDF

    2. Alter Session/System Set Events

      • Norbert Debes
      Pages 129-133

    3. Alter Session Set Current_Schema

      • Norbert Debes
      Pages 135-141
Back to top

About this book

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.

Back to top

Keywords

Back to top

About the author

Norbert Debes has more than 13 years experience as an Oracle database administrator. He holds a master's degree in computer science from the University of Erlangen, Germany, and is an Oracle8, Oracle8i, and Oracle9i certified professional Oracle database administrator. For over 6 years, he held different positions and technical roles at Oracle Germany. He was a team leader in Oracle Support Services, and a technical account manager in Strategic Alliances. In his last role at Oracle, Norbert was responsible for promoting Real Application Clusters on a technical level. During his tenure, he contributed to the Oracle9i SQL Reference, the Real Application Clusters manual set, and to various Real Application Clusters training materials. Right from the beginning of his quest in the Oracle database management system, Norbert always wanted to know exactly how things worked. He would not be satisfied with superficial explanations, but demanded evidence. His passion to dig deeper served him well in acquiring extensive knowledge of the Oracle database, and occasionally makes him a restless researcher who often ends up working from dusk until dawn when captured by ""the flow."" In his spare time, Norbert likes to hike, snowboard, play basketball, and read nonfiction on topics such as the emotional brain. Furthermore, he is a passionate analog and digital photographer. Having been intrigued by the vibrancy of stereoscopic (i.e., three-dimensional) capture for 20 years, he rejoices in his recent acquisition of a stereo camera.
Back to top

Bibliographic Information

Back to top

Publish with us

Policies and ethics

Back to top
Access via your institution

Buy it now

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Search

Navigation