O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Database 12c Release 2 New Features

Book Description

Leverage the New and Improved Features of Oracle Database 12c

Written by Oracle experts Bob Bryla and Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you’ll find everything you need to know to get up and running quickly on Oracle Database 12c Release 2. Supported by contributions from Oracle expert Eric Yen, Oracle Database 12c Release 2 New Features offers detailed coverage of:

• Installing Oracle Database 12c and Grid Infrastructure
• Architectural changes, such as Oracle Multitenant
• The most current information on upgrading and migrating to Oracle Database 12c
• The pre-upgrade information tool and parallel processing for database upgrades
• Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System
• Enhanced and new online operations: tables, indexes, and PDBs
• Oracle RMAN enhancements, including cross-platform backup and recovery
• Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync
• SQL, PL/SQL, DML, and DDL new features
• Improvements to partitioning manageability, performance, and availability
• Advanced business intelligence and data warehousing capabilities
• Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges
• Manageability, performance, and optimization improvements

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. Acknowledgments
  6. Introduction
  7. 1 Getting Started with Oracle Database 12c Release 2
    1. Downloading Oracle Database 12c Release 2 Components
    2. Preparing the Operating System for Oracle Database 12c Release 2
      1. Review the Installation Guide and Readme Files
      2. Make Sure Your OS Platform Has All Required Updates Installed
      3. Make Sure Your Platform Meets the Minimum Requirements
      4. Create the Required OS Groups and Users
      5. Configure the Kernel Parameters
      6. Check for Patches
      7. Finish the Preinstall Steps
    3. Installing Oracle Database 12c Release 2
      1. Prepare the Installation Environment
      2. Install Oracle Database 12c Release 2 Using the OUI
    4. Installing Oracle Database 12c Release 2 Grid Infrastructure
      1. Prepare to Install Oracle Database 12c Release 2 Grid Infrastructure
      2. Stage Oracle Database 12c Release 2 Grid Infrastructure
    5. Deinstalling Oracle Database 12c Release 2
    6. Summary
  8. 2 Installing or Upgrading to Oracle Database 12c Release 2
    1. Installing Oracle Database 12c Release 2 Grid Infrastructure
      1. Configure Grid Infrastructure and Start ASM
      2. Add the RECO Disk Group Using asmca
    2. Creating a New Oracle Database 12c Release 2 Database
    3. Upgrading to Oracle Database 12c Release 2: Traditional Architecture
      1. Upgrade Paths
      2. Preparing for an Upgrade
      3. The Last Word on Upgrading the Traditional Architecture
      4. In the Event of Failure
    4. Upgrading to Oracle Database 12c Release 2: Multitenant Architecture
      1. Upgrade Methods for Multitenant Databases in Oracle Database 12c Release 2
      2. In the Event of Failure
    5. Going...Going...Gone: Deprecated and Desupported Features
      1. Features Deprecated in Oracle Database 12c Release 2
      2. Features Desupported in Oracle Database 12c Release 2
      3. Deprecated Parameters in Oracle Database 12c Release 2
      4. Desupported Parameters in Oracle Database 12c Release 2
    6. Summary
  9. 3 Oracle Database 12c Release 2 Multitenant New Features
    1. New Features Related to Creating Pluggable Databases
      1. Support for Thousands of PDBs for Each Container Database
      2. Parallel PDB Creation
      3. Hot and Cold Cloning a PDB
      4. Creating a PDB with a Default Tablespace
      5. Support for Different Character Sets in PDBs
      6. PDB Support for Different Database Time Zones
      7. PDB Support for Different Database Time Zone Files
    2. Moving, Copying, and Migrating PDBs
      1. Cloning a PDB in READ WRITE Mode
      2. Incrementally Refreshing a Read-Only PDB
      3. Flashback a PDB
      4. Relocating a PDB
      5. Manually Transporting PDBs Across Platforms
      6. Using PDB Archive Files when Unplugging a PDB
    3. PDB Security: Lockdown Profiles
    4. Multitenant Performance-Related New Features
      1. Controlling SGA Use at the PDB Level
      2. Resource Manager Changes Related to CDBs and PDBs
    5. Summary
  10. 4 Application Containers and Hints Thereof
    1. Application Containers
      1. Creating the Application Container
      2. Creating the Application in the Application Root
      3. Creating an Application PDB
      4. Installing, Upgrading, and Patching the Application Container
      5. Creating the Application Seed
    2. Using Hints in the Containers Query
    3. Summary
  11. 5 Administrative, High Availability, and Security New Features
    1. Administration
      1. Online Table Redefinition
      2. Converting Nonpartitioned Tables to Partitioned Tables
      3. Creating a New Table with Partition Characteristics
    2. High Availability
      1. RAC and Grid Infrastructure
      2. Automatic Storage Management
      3. Sharding
    3. Security
      1. Encryption and Redaction
      2. Database Vault
      3. Auditing
      4. Privilege Analysis
      5. Separation of Duties
      6. User and Password Management
      7. STIG
    4. Summary
  12. 6 RMAN New Features
    1. Table Recovery Enhancements
    2. RMAN High Availability and Security Enhancements
      1. Using RMAN to Duplicate TDE Tablespaces
      2. Cross-Platform Transport Using RMAN
      3. Backup and Recovery of Sparse Databases on Exadata
    3. Cloud Control, PDB Archives, and RMAN, Oh My!
      1. Unplugging a PDB Using RMAN and Cloud Control
      2. Plugging In a PDB Using RMAN and Cloud Control
    4. Summary
  13. 7 Performance-Related New Features
    1. Monitoring Index Usage
      1. DBA_INDEX_USAGE
      2. V$INDEX_USAGE_INFO
    2. Optimizer Statistics Advisor
      1. Rules
      2. Findings
      3. Recommendations
      4. Actions
    3. In-Memory Enhancements
      1. Initialization Parameters
      2. Dynamic Memory Area for In-Memory Objects
      3. New In-Memory Objects
      4. In-Memory FastStart
      5. Compress Join Groups
    4. Per-Process PGA Limits
    5. Summary
  14. 8 Compression and Archiving
    1. NFS Server in the Database
      1. Prerequisites for Setting Up an NFS Server in the Database
      2. Creating a DBFS File System
      3. Installing NFS Server in the Database
      4. Using the NFS Client Interface
      5. Tuning NFS Server in the Database
      6. OFS Dynamic Performance and Data Dictionary Views
    2. Using Advanced Index Compression
      1. Using COMPRESS in Oracle Database 11g
      2. Using COMPRESS ADVANCED LOW in Oracle Database 12c Release 1
      3. Using COMPRESS ADVANCED HIGH
    3. Improvements to Hybrid Columnar Compression (HCC)
      1. HCC Array Inserts
      2. HCC with Automatic Data Optimization (ADO)
    4. Summary
  15. 9 Big Data, Business Intelligence, and Data Warehousing New Features
    1. Leveraging New Partitioning Methods
      1. Using Interval Partitioning with Subpartitions
      2. List Partitioning Enhancements
      3. Partitioning External Tables
    2. Materialized View Performance Improvements
    3. Summary
  16. 10 Utilities and Scheduler New Features
    1. Oracle Data Pump Parallel Metadata Management
    2. External Table Access Driver Improvements
      1. In-Memory Scheduler Jobs
      2. In-Memory Runtime Jobs
      3. In-Memory Full Jobs
    3. Summary
  17. 11 New Features for Developers, Report Writers, and Power Users
    1. New and Enhanced Functions
      1. CAST
      2. VALIDATE_CONVERSION
      3. LISTAGG
    2. Approximate Query Processing
      1. Configuring Approximate Query Processing
      2. Using Approximate Query Processing
    3. Data Dictionary and Data Type Enhancements
      1. Identifier Length Changes
      2. New Data Dictionary Views
    4. Summary
  18. 12 Integrating with Oracle Enterprise Manager Cloud Control 13c Release 2
    1. Configuring a Cloud Control Repository
    2. Installing Cloud Control 13c
    3. Leveraging New Cloud Control 13c Features
      1. Support for Oracle Database 12c Release 2
      2. Other Features Worth Mentioning
    4. Summary
  19. Index