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