Logo - springer
Slogan - springer

Computer Science - Database Management & Information Retrieval | Secrets of the Oracle Database

Secrets of the Oracle Database

Debes, Norbert

2009, 450 p.

A product of Apress
Available Formats:
eBook
Information

Springer eBooks may be purchased by end-customers only and are sold without copy protection (DRM free). Instead, all eBooks include personalized watermarks. This means you can read the Springer eBooks across numerous devices such as Laptops, eReaders, and tablets.

You can pay for Springer eBooks with Visa, Mastercard, American Express or Paypal.

After the purchase you can directly download the eBook file or read it online in our Springer eBook Reader. Furthermore your eBook will be stored in your MySpringer account. So you can always re-download your eBooks.

 
$41.99

(net) price for USA

ISBN 978-1-4302-1953-8

digitally watermarked, no DRM

Included Format: PDF

download immediately after purchase


learn more about Springer eBooks

add to marked items

Softcover
Information

Softcover (also known as softback) version.

You can pay for Springer Books with Visa, Mastercard, American Express or Paypal.

Standard shipping is free of charge for individual customers.

 
$59.99

(net) price for USA

ISBN 978-1-4302-1952-1

free shipping for individuals worldwide

usually dispatched within 3 to 5 business days


add to marked items

  • 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

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.

Content Level » Popular/general

Keywords » DBMS - Interface - Oracle - SQL - business intelligence - database - database administration - performance

Related subjects » Database Management & Information Retrieval - Hardware

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

Popular Content within this publication 

 

Articles

Read this Book on Springerlink

Services for this book

New Book Alert

Get alerted on new Springer publications in the subject area of Database Management.