Oracle Database 12c New Features

by Robert G. Freeman

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Maximize the New and Improved Features of Oracle Database 12c

Written by Master Principle Database Expert, Oracle, and Oracle ACE 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. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of:

• Installing Oracle Database 12c
• 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
• 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

Product Details

ISBN-13:	9780071799317
Publisher:	McGraw Hill LLC
Publication date:	12/13/2013
Pages:	480
Product dimensions:	7.40(w) x 9.10(h) x 1.00(d)

About the Author

Robert G. Freeman, OCP, is a Master Principle Database Expert for Oracle who has been working with Oracle databases for more than 20 years. He is a Principle Database Engineer for the Church of Jesus Christ of Latter-day Saints in Salt Lake City, UT. Robert is the author or co-author of several Oracle Press titles, including Portable DBA: Oracle; Oracle Database 11g New Features; Oracle RMAN 11g Backup and Recovery; Oracle GoldenGate 11g Handbook, and others.

Table of Contents

Foreword xix

Acknowledgments xxi

Introduction xxv

1 Getting Started with Oracle Database 12c 1

Downloading and Staging Oracle Database 12c 2

Preparing to Install Oracle Database 12c 3

Review the Install Guides and Read-Me Files 4

Make Sure Your OS Platform Has All Required Updates Installed 4

Make Sure Your Platform Meets the Minimum Requirements 5

Create the Required OS Groups and Users 7

Configure the Kernel Parameters 8

Check Whether Any Patches Are Required Prior to the Install 8

Finish the Pre-Install Steps 8

Installing and Deinstalling Oracle Database 12c 9

Prepare to Start the OUI 10

Install Oracle Database 12c Using the OUI 11

Deinstall Oracle Database 12c with the OUI 40

The Death of Database Control and Birth of Database Express 42

Database Express Prerequisites 43

Accessing Database Express 43

Navigating Database Express 43

End of Line 49

2 Upgrading and Migrating to Oracle Database 12c 51

Introductory Comments 52

The Difference Between Upgrading and Migrating a Database 52

Upgrading Is Complex-Tread Carefully 53

Why Upgrade-What's the Big Deal 54

New Features Related to Upgrading to Oracle Database 12c 55

Pre-Upgrade Information Tool 56

Parallel Processing for Database Upgrades 56

Restartable DBUA 56

Pre- and Post-Upgrade Summary Report Enhancements 57

Installation of Oracle XML Database During the Upgrade 57

Preparing for an Upgrade to Oracle Database 12c 57

Read, and Then Read Some More 58

Testing 58

Check for Compatibility Issues 62

Consider Removing Database Control Before You Upgrade 63

Back Up the Source Database 64

Choose an Upgrade or Migration Method 65

More About the Pre-Upgrade Information Tool 69

Getting Ready to Upgrade or Migrate 74

Upgrading to Oracle Database 12c with the Database Upgrade Assistant 77

Starting the DBUA 77

Upgrading with DBUA 78

Upgrading to Oracle Database 12c Manually 92

Manual Upgrade Pre-Upgrade Steps 93

Performing the Manual Upgrade 93

Manual Upgrade Post-Upgrade Steps 96

Other Post-Upgrade Steps to Consider 97

Migrating to Oracle Database 12c with Oracle Data Pump 98

The Benefits of Using Oracle Data Pump When Migrating to Oracle Database 12c 99

Using Oracle Data Pump to Migrate Your Database to Oracle Database 12c 100

Rolling Upgrades 106

Rolling Back the Upgrade 107

Miscellaneous Changes to Be Aware of After Upgrading 108

End of Line 108

3 Oracle Multitenant 109

Introducing Oracle Multitenant 111

The Multitenant Container Database 113

The Pluggable Database 123

CDBs and PDBs and the Data Dictionary 129

The CDB Data Dictionary and V$ Views 129

The PDB Data Dictionary 132

CDB/PDB Administration 133

CDB/PDB Object Administration Data Dictionary Queries 137

Creating, Deleting, and Modifying PDBs 140

Creating a PDB from the Seed Database 141

Cloning a PDB from an Existing PDB 142

Cloning a PDB from a PDB in a Remote CDB 144

Unplugging a PDB and Plugging a PDB into a CDB 146

Plugging in a Non-CDB as a PDB 151

Removing a PDB 154

Renaming a PDB 154

Using Oracle Multitenant as a Consolidation Tool 155

Oracle Multitenant and Resource Management 155

Administration of CDBs and PDBs 156

Administration of CDBs 156

Administration of PDBs 157

Backup and Recovery of CDBs and PDBs 161

Backup Features Available at the CDB Level 161

Backup Features Available for PDBs 162

RMAN Restore and Recovery Features for CDBs and PDBs 165

Other Backup and Recovery Features for CDBs and PDBs 167

End of Line 168

4 Oracle Grid Infrastructure 169

Flex Clusters 171

Flex ASM 173

Flex ASM Architecture 174

Installing and Configuring Flex ASM 175

ASM Enhancements 177

Password Files 178

ASM Rebalance and Resync 178

ACFS Enhancements 178

File Support 179

Highly Available NFS 181

ACFS Snapshots 181

Other Enhancements 182

End of Line 182

5 Backup, Recovery, and Data Guard New Features 183

RMAN-Related New Features 184

Improvements in Incremental and Multisection Backups 184

Recovery of Databases Over the Network Using Backup Sets from a Standby Database 186

Active Database Duplication Improvements 189

Cross-Platform Backup and Recovery Improvements 189

Recovering Tables and Partitions with RMAN 201

Miscellaneous RMAN New Features 207

Oracle Data Guard New Features 210

The SYSDC Privilege 210

The Far Sync Instance 210

Cascaded Redo Transport Destinations 210

Fast-Sync Mode 211

Other New Standby Database and Data Guard Features 211

End of Line 212

6 Oracle Database 12c SQL and PL/SQL New Features 213

Oracle Database 12c DML New Features 214

Row Pattern Matching 214

Enhancements to the Oracle Native Left Outer Join Syntax 223

Top-n Query New Features 223

Concurrent Execution of Union and Union All Branches 227

Oracle Database 12c DDL New Features 227

Increased Size Limits for VARCHAR2, NVARCHAR2, and RAW Data Types 228

Identity Columns 229

Cascading Truncate Statements 232

Invisible Columns 233

Default Values for Columns Based on Oracle Sequences 235

Default Values for Columns on Explicit NULL Insertion 237

Sequence-Related New Features 238

Creating Multiple Indexes on the Same Column Set 239

With Clause New Features 240

Oracle Database 12c PL/SQL New Features 242

Using the Bequeath Clause on Views 242

PL/SQL Subprogram White Lists 242

Using PL/SQL-Specific Data Types Across the PL/SQL-to-SQL Interface 244

Changes to Security Privileges on Invoker Rights PL/SQL Program Units 245

Granting Roles to PL/SQL Packages and Stand-Alone Subprograms 246

A Final Word on PL/SQL New Features 248

End of Line 249

7 Partitioning Enhancements 251

Moving Partitions Online 252

Interval-Reference Partitioning 255

Cascade Functionality 256

Partition Maintenance Operations on Multiple Partitions 257

Partial Indexes 259

Creating Partitions With or Without Indexing 260

Partial Indexing of Partitions Within a Partitioned Table 261

Global Index Maintenance 262

Automatic Global Statistics 262

End of Line 264

8 Business Intelligence and Data Warehousing 265

Advanced Analytics 266

New Algorithms 266

Search Capabilities 267

Prediction Detail Functions 267

OLAP 267

Information Lifecycle Management 268

In-Database Archiving and Temporal Validity 268

Automatic Data Optimization 277

Compression 288

Temporal History 289

In-Database Archiving, Temporal Validity, and Temporal History 289

Performance Enhancements 290

End of Line 290

9 Security New Features 291

Auditing 292

Changes in the SGA 292

Separation of Duties 294

Basic Audit Information 294

Extended Audit Information 296

Privilege Analysis 298

Privilege Analysis Overview 298

Privilege Analysis Example 298

Data Redaction 302

Data Redaction Scenario 302

Miscellaneous Security Improvements 308

Mixing and Matching Security Features 309

End of Line 310

10 Oracle Database 12c Manageability New Features 311

Online Operations 312

Enhanced Online DDL Capabilities 312

Lock Timeout Available for Online Redefinitions 313

Move a Datafile Online 313

Single Command to Redefine Certain Table or Partition Storage-Related Definitions 315

Support for Redefinition of Tables with VPD Policies 316

Database Monitoring and Administration 317

Oracle Enterprise Manager Database Express 317

Real-Time Database Operations Monitoring 319

Real-Time ADDM Monitoring 320

Miscellaneous Manageability Features 320

PGA Size Limits 320

New Administrator Privileges 321

Real Application Testing Changes 322

End of Line 338

11 Oracle Database 12c Performance New Features 339

Statistics-Related New Features 340

Automatic Column Group Detection 340

Concurrent Statistics Gathering 347

Enhancements to Incremental Statistics 350

Online Statistics Gathering for Bulk Loads 352

Session-Private Statistics for Global Temporary Tables 353

Running Statistics Gathering Options in Reporting Mode 355

Reports on Past Statistics Collection Operations 356

Optimizer-Related New Features 357

Adaptive Query Optimization 358

Histograms 380

End of Line 385

12 Other Oracle Database 12c New Features 387

Data Pump Export and Import New Features 388

The views_as_tables Parameter 389

Moving Databases Across Platforms, Regardless of Byte Format, with Transportable Tablespaces 393

Transform Clause New Features 404

Data Pump Fully Supports Oracle's New Multitenant Database Technologies 405

Enable Unified Auditing for Data Pump Jobs 406

Miscellaneous Enhancements to Data Pump 407

Oracle SQL*Loader Enhancements 408

SQL*Loader Express Mode 408

SQL*Loader Support for Identity Columns 412

SQL*Loader Support for Extended Data Types 412

SQL*Loader Support for Unified Auditing 413

SQL*Loader dNFS-Related Features 413

SQL*Loader Control File New Clauses 414

SQL*Loader Command-Line Enhancements 415

Oracle External Table Enhancements 416

Oracle Log Miner Enhancements 416

ADR DDL and Debug Logs 417

Oracle SecureFiles Enhancements 417

Oracle R Enterprise, Hadoop, and MapReduce 417

Oracle R Enterprise 418

Hadoop/MapReduce in the Oracle Database 418

CloneDB 419

SQL Translation Framework 420

End of Line 420

A Deprecated and Desupported Features in Oracle Database 12c 423

Defining Deprecation and Desupport 424

Deprecated Features in Oracle Database 12c 424

Desupported Features in Oracle Database 12c 426

Deprecated Parameters in Oracle Database 12c 427

Deprecated Views in Oracle Database 12c 428

B New Parameters and Views in Oracle Database 12c 429

New Parameters in Oracle Database 12c 430

New Views in Oracle Database 12c 431

Index 441