Oracle Database 11g: New Features for DBAs and Developers

Oracle Database 11g: New Features for DBAs and Developers

by
Released November 2007
Publisher(s): Apress
ISBN: 9781590599105

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation's flagship database product.

  • Learn what's new in Oracle that really counts

  • See actual examples and test run output

  • Make sound decisions on new feature adoption

Sift the gold from the silt and discover which new features of the latest release of Oracle's flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real-world to help you get the most out of Oracle Database 11g.

Table of contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Authors
  6. Acknowledgments
  7. Introduction
    1. Change Management
    2. Enhanced Database Automation
    3. Performance Management
    4. Enhanced Fault Diagnosis Capability
    5. Data Guard Enhancements
    6. Storage Management Improvements
    7. General Database Management
    8. Enhanced Security
    9. Application Improvements
    10. Partitioning New Features
    11. High-Availability Enhancements
    12. Advanced Compression
  8. CHAPTER 1: Installing, Upgrading, and Managing Change
    1. New Features in Server Installation
    2. Installing Oracle Database 11g
    3. New Features in Database Creation
    4. Upgrading to Oracle Database 11g
    5. Real Application Testing
    6. Database Software Patching
  9. CHAPTER 2: Database Diagnosability and Failure Repair
    1. The Fault Diagnosability Infrastructure
    2. Investigating and Resolving Problems
    3. Database Health Checks
    4. Data Recovery Advisor
    5. Improvements in Handling Data Corruption
  10. CHAPTER 3: Database Administration
    1. Database Automation
    2. Flashback-Related New Features
    3. Database Administration New Features
    4. SQL*Plus New Features
    5. Online Application Maintenance
    6. Oracle Advanced Table Compression Option
    7. Enterprise Manager New Features
    8. Oracle Scheduler New Features
  11. CHAPTER 4: Performance Management
    1. SQL and PL/SQL Performance Enhancements
    2. New Result Caching Functionality
    3. Automatic SQL Tuning
    4. Optimizer and Statistics Collection Enhancements
    5. Performance-Related Changes in Database Control
  12. CHAPTER 5: Database Security
    1. Enterprise Database Security Concerns
    2. Tablespace Encryption
    3. Enterprise Manager Integration
    4. UTL_ Package Network Access Management
    5. Oracle Advanced Security Features
    6. Oracle Call Interface Enhancements
  13. CHAPTER 6: Backup and Recovery
    1. Enhanced Block Media Recovery
    2. RMAN Management Enhancements
    3. Active (Network-Based) Database Duplication
    4. Recovery Catalog Management
    5. Enhanced RMAN Integration with Data Guard
  14. CHAPTER 7: Data Pump
    1. API Enhancements
    2. Compression Enhancements
    3. Encryption
    4. Reusing a Dump File
    5. Remapping Data
    6. Remapping a Table
    7. Export and Import of Partitions
    8. Ignoring Errors
    9. External Tables Based on Data Pump
  15. CHAPTER 8: Oracle Streams
    1. Synchronous Capture
    2. Combined Capture and Apply
    3. Performance Advisor
    4. Streams Topology
    5. DBMS_COMPARISON for "Compare and Repair"
    6. Splitting and Merging of a Destination
    7. Usability Improvements
  16. CHAPTER 9: Storage Management
    1. Automated Storage Management
    2. ASM Upgrade
    3. ASM Preferred Reads
    4. asmcmd Commands
    5. Metadata Backup and Restore
    6. Oracle Direct NFS
  17. CHAPTER 10: Data Guard
    1. Active Physical Standby Database Duplication
    2. Real-Time Query Standby
    3. Snapshot Standby
    4. Using the Physical Standby for Rolling Upgrades
    5. Logical Standby: SQL Apply
    6. Data Guard Broker
  18. CHAPTER 11: Application Development
    1. New PL/SQL Features
    2. New Trigger Features
    3. XML DB Improvements
    4. Application Express (APEX) Enhancements
    5. PHP Support Enhancements
    6. Java Enhancements
  19. CHAPTER 12: Data Warehousing
    1. Next-Generation LOBs
    2. Data Warehousing New Features
    3. Partitioning
    4. Oracle Multimedia
  20. Index

Product information

  • Title: Oracle Database 11g: New Features for DBAs and Developers
  • Author(s):
  • Release date: November 2007
  • Publisher(s): Apress
  • ISBN: 9781590599105