You are previewing Oracle Database 11g New Features.
O'Reilly logo
Oracle Database 11g New Features

Book Description

Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:

  • New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components

  • Improved Automated Memory Management capabilities

  • New database design features, such as virtual columns, tablespace encryption, and true table-level data compression

  • New Database Advisors for data recovery and repair, partitioning, and streams performance

  • New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer

  • Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization

  • Improved auditing and security capabilities

  • Advanced BI, data warehousing, and partitioning features

  • New SQL and PL/SQL enhancements

Table of Contents

  1. Cover Page
  2. Oracle Database 11g New Features
  3. Copyright Page
  4. Dedication Page
  5. about
  6. Contents
  10. 1 Oracle Database 11g Getting Started
    1. Installing Oracle Database 11g
    2. The Database Configuration Assistant
    3. Upgrading to Oracle Database 11g
      1. Saving Time When Upgrading
      2. Supported Upgrade Paths
      3. Supported Upgrade Methods
      4. Upgrade with DBUA
      5. Manual Upgrades
      6. Using Export/Import for Upgrades and Rollback
      7. Upgrade Using Data Copying
    4. Oracle Parameter Changes
      1. New Parameters
      2. Deprecated Parameters
      3. Obsolete Parameters
      4. Undo_Management Parameter Madness
    5. Oracle Dictionary View Changes
    6. End of Line
  11. 2 Oracle Database New Management Features
    1. ASM-Related Changes and New Features
      1. New ASM-Related Documentation
      2. ASM Disk Group Attributes
      3. ASM Fast Disk Resync
      4. ASM Compatibility Settings
      5. ASM Preferred Mirror Read
      6. ASM Rolling Upgrades
      7. ASM Support for Variable Allocation Unit Sizes
      8. New SYSASM Role
      9. New asmcmd Commands
    2. Automatic Memory Management
      1. Overview of Automatic Memory Management
      2. New Memory Advisor Functionality and Views
      3. How Is Oracle Managing My Memory?
      4. Automatic Memory Management and OEM
      5. Converting to Automatic Memory Management
    3. ADDM New Features
      1. ADDM New Views
      2. ADDM Now RAC-Aware
      3. Managing ADDM Through DBMS_ADDM
      4. Finding Classifications
      5. Directives
    4. AWR New Features
      1. Default Retention of AWR Snapshots Changed
      2. AWR Baseline New Features
      3. Adaptive Metric Thresholds
    5. Scheduler AutoTask Automated Maintenance Tasks
      1. AutoTask Architecture
      2. AutoTask Dictionary Views
      3. Managing AutoTask Tasks via OEM
      4. Managing AutoTask Tasks Manually
      5. AutoTask Maintenance Windows
    6. Parameter File Management Changes and New Features
      1. Read/Write Error Handling of SPFILES
      2. Easier Conversion to the Use of SPFILES
      3. Users Are Prevented from Setting Invalid Values in SPFILES
    7. Resource Manager Changes and New Features
      1. IO Calibration
      2. Default Maintenance Plan
      3. Built-In Resource Plans
      4. Resource Manager Statistics in AWR
      5. Resource Manager Plan Directive New Features
    8. Finer-Grained Dependencies
    9. DDL WAIT Option Now Default
    10. New Add Column Functionality
    11. End of Line
  12. 3 Oracle Database New Availability and Recovery Features
    1. Fault Diagnosability Infrastructure
      1. The Automatic Diagnostic Repository (ADR)
      2. The Alert Log
      3. Trace, Dump, and Core Files
      4. The Support Workbench
    2. RMAN New Features
      1. Interfile Backup Parallelism
      2. Faster Backup Compression
      3. Active Database Duplication
      4. Improved Handling of Long-Term Backups
      5. Backup Failover for Archived Redo Logs
      6. Archived Redo Log Deletion Policy Enhancements
      7. Recovery Catalog Enhancements
      8. Undo Backup Optimization
      9. Block Media Recovery Performance Improved
      10. Other RMAN New Features
    3. Oracle Flashback-Related New Features
      1. Oracle Flashback Transaction Backout
      2. Oracle Flashback Data Archives
    4. Oracle Standby Database New Features
      1. Lost-Write Detection
      2. Compression of Archived Redo Logs
      3. Real-Time Query Capabilities from a Physical Standby Database
      4. Snapshot Databases
    5. Oracle Data Pump New Features
      1. Exp Utility Deprecated
      2. Compression of Dump File Sets
      3. Data Pump Encryption Enhancements
      4. Data Pump Data Remapping (Obfuscation)
      5. Data Pump Rename Table
      6. Data Pump and Partitioned Tables
      7. Overwrite Dump Files
      8. Data Pump Data_Options Parameter
      9. The Transportable Parameter
    6. End of Line
  13. 4 Oracle Database Advisors
    1. The Data Recovery Advisor
      1. The SQL Repair Advisor
      2. The SQL Access Advisor
      3. The Streams Performance Advisor
      4. Oracle Database 10g Database Advisor Views
    2. End of Line
  14. 5 Oracle Database Change Management
    1. Database Replay
      1. Using Oracle Database Replay
      2. Database Replay—Overview
      3. Database Replay Workload Support and Limitations
      4. Database Replay—Capture Workload
      5. Database Replay—PreProcess the Captured Workload
      6. Database Replay—Replay Workload
    2. The SQL Performance Analyzer
      1. Overview of SQL Performance Analyzer
      2. SQL Performance Analyzer via OEM
      3. SQL Performance Analyzer via PL/SQL
    3. End of Line
  15. 6 Oracle Database 11g Security
    1. Auditing
    2. Password-Related Features
      1. Password Settings and the Default Profile
      2. Password Complexity
      3. Password Case Sensitivity
      4. Hacking Prevention with Failed Logon Delays
      5. Password Hashing Changes
      6. Default Password Use
    3. Fine-Grained Access Control on Network Services
      1. Create the ACL and Define the Associated Privileges
      2. Assign the ACL to Network Hosts
      3. ACL-Related Data Dictionary Views
    4. Tablespace Encryption
      1. Overview of Oracle Tablespace Encryption
      2. Preparing the Database for Tablespace Encryption
      3. Creating Encrypted Tablespaces
      4. Encryption and Database Performance
    5. TDE and Log Miner, Logical Standby, and Streams
    7. End of Line
  16. 7 Oracle Database BI and Data Warehousing New Features
    1. Partitioning
      1. Interval Partitioning
      2. Extended Composite Partitioning
      3. Reference Partitioning
      4. System Partitioning
      5. System-Managed Domain Indexes
    2. Virtual Columns
      1. About Virtual Columns
      2. Creating Tables with Virtual Columns
      3. Partitioning Tables with Virtual Columns
    3. Data Pump Single-Partition Imports
    4. Materialized Views and Query Rewrite
    5. Online Redefinition for Tables with Materialized View Logs
      1. Query Rewrite During Refresh
      2. Partition Change Tracking Refresh for Union All Mviews
      3. New and Enhanced Materialized View Catalog Views
      4. Query Rewrite Enhancements
    6. The Pivot and Unpivot Clauses
      1. The Pivot Clause
      2. The Unpivot Clause
    7. Table Compression
    8. End of Line
  17. 8 Application Development
    1. SQL*Plus
      1. New set Commands
      2. Fast Application Notification Events in an RAC Database
    2. Online Application Maintenance and Upgrade
      1. New lock table Parameter
      2. Fewer Exclusive Locks Taken During Online Operations
      3. Invisible Indexes
    3. SQL
      1. Read-Only Tables
      2. SQL Query Result Cache
      3. Client Side Result Cache
      4. Regular Expression Enhancements
      5. Named and Mixed Notation from SQL
    4. PL/SQL
      1. Create Triggers as Enabled or Disabled
      2. Create Trigger Follows Clause
      3. Compound Triggers
      4. Inlining
      5. SIMPLE_INTEGER Datatype
      6. PL/SQL Function Result Cache
      7. Dynamic SQL
      8. Dynamic SQL and REF Cursors
      9. PLW 06009 Warning
      10. PL/SQL Sequence Enhancement
      11. PL/SQL Continue Statement
    5. End of Line
  18. 9 Performance Tuning
    1. Enhanced Oracle Process Monitoring
    2. Statistics
      1. Pending and Published Statistics
      2. Recovering Previous Statistics
      3. Extended Statistics
    3. PL/SQL Native Compilation
    4. SQL Plan Management
      1. SQL Plan Management Overview
      2. Plan Capture
      3. Use of SQL Plan Baselines
      4. Querying SQL Plan Baselines
      5. Evolving SQL Plan Baselines
      6. Managing SQL Plan Baselines
    5. Automatic SQL Tuning
      1. Overview of Automatic SQL Tuning
      2. Automatic SQL Tuning with OEM
      3. Manage Automatic SQL Tuning Manually
    6. Manual Creation and Use of SQL Tuning Sets
      1. Create the Task
      2. Create the SQL Tuning Set
      3. Load the SQL Tuning Set
      4. Link the SQL Tuning Set and the Task
      5. Set Any Task Parameters
      6. Execute the Task
      7. Review the Results
    7. Intelligent Cursor Sharing (Bind-Aware Peeking)
      1. About Bind-Aware Peeking
      2. Bind-Aware Peeking Views
      3. Starting a System with Bind-Aware Peeking
    8. Temporary Tablespace Features
      1. Temporary Tablespace Shrink
      2. The DBA_TEMP_FREE_SPACE View
    9. Real-Time SQL Monitoring
      1. Real-Time SQL Monitoring Overview
      2. Real-Time SQL Monitoring Views
      3. Real-Time SQL Monitoring Report
      4. Control Real-Time SQL Monitoring
    10. Control the Use of OEM Management Packs
    11. End of Line
  19. 10 Other New Features and Enhancements
    1. Real Application Clusters
      1. OCI Runtime Connection Load Balancing
      2. Using XA Transactions with RAC
      3. RAC Configuration Assistants
      4. Network Configuration Assistant (NetCA)
      5. Database Rolling Upgrade
      6. Parallel Execution Honors Service Placement
      7. Direct NFS
    2. XMLDB New Features
      1. Binary XML Storage
      2. Partitioning Support for XMP
      3. XQuery Enhancements
      4. Database Native Web Services
      5. XML DB Repository Enhancements
      6. XML Developers Kit
    3. Java
      1. Oracle JVM-Related Features
      2. Enhancements to Existing Utilities
      3. The ojvmtc Utility
      4. JDBC 4.0 Support
      5. JDK Support in Oracle Database 11g
    4. New Oracle Supplied Packages and Procedures
  20. A Arup's Top Ten Features
    1. Arup's Top Feature #1: Database Replay
    2. Arup's Top Feature #2: SQL Performance Analyzer
    3. Arup's Top Feature #3: Partitioning
    4. Arup's Top Feature #4: Transparent Tablespace Encryption
    5. Arup's Top Feature #5: Flashback Data Archive
    6. Arup's Top Feature #6: SQL Plan Management
    7. Arup's Top Feature #7: Private Statistics
    8. Arup's Top Feature #8: More Concurrency
    9. Arup's Top Feature #9: Result Cache
    10. Arup's Top Feature #10: Better-Quality PL/SQL Code
  21. Index