Oracle 12c grid database is the next incarnation of Oracle's flagship database management system, noted as the world's most flexible and robust data storage platform. Many of the Oracle 12c new features are intended to automate the inherent complexity of the Oracle engine, and this book on Oracle 12c new features explores all of the new features from the perspective of a working Oracle professional. This Oracle 12c new features book shows only the important Oracle 12c enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 12c functionality. This comprehensive Oracle12c new features book explores those enhancements most useful to Oracle users: 12c SQL new features 12c language & PL/SQL new features 12c DBA features 12c RAC new features & enhancements 12c performance features 12c security new features 12c Enterprise Manager (OEM) new features This book is the indispensable reference for Oracle 12c new features for both DBA's and Oracle developers and programmers.

The Premier Book of Oracle 12c New Features *

Specific topics will include:

• Metadata only default of optional columns
   
• New BBED commands
   
• RAC Transaction guard - evolution of TAF
   
• Oracle database file system (ODFS)
   
• WITH clause enhancement to allow functions
   
• Interval-REF partitioning
   
• Simultaneous operations on multiple partitions
   
• Identity columns (automatic primary key generation)
   
• VARCHAR2(32767) for LOB's (up from VARCHAR(4000). Less than 4K is stored inline. More than 4K row lengths are stored out of line (BFILE)
   
• Invisible data columns
   
• alter database move datafile
   
• max_sql_string_size
   
• Booleans in SQL
   
• Row pattern matching (improved regex?)
   
• New Cascade option for TRUNCATE and EXCHANGE partition
   
• Improved optimizer statistics
   
• The new 12c data pump will allow to turn off redo for the import operation only
   
• ILM clause
   
• 12c Transaction Guard
   
• Hybrid Histograms
   
• Adaptive execution plan
   
• Pluggable Database
   
• Real-time ADDM
   
• ASH Analytics
   
• SQL Commonality Index
   
• Oracle12c de-support of RAC raw volumes

Oracle 12c RAC New Features:

• Application Continuity

• Oracle Flex ASM: With this feature, database instances use remote ASM instances.

• Oracle ASM Disk Scrubbing: Checks for logical data corruptions and repair them automatically.

• Enhancements to Policy-based Databases: Actively utilizes different sized servers

• What - if analysis for server pool management

• Standardized deployment and patching: Introducing GHS, rapid home provisioning and gold images

• A new "ghctl" command for better patching

• Oracle Utility Cluster

• Dynamic IP Management and name resolution made easy

• IPv6 Based IP Addresses Support for client connectivity

• Multi-purpose Installation

• Oracle installer will run Fix-up scripts & "root.sh" scripts across nodes. You don't have to run the scripts manually on RAC nodes.

About the Author:

Table of Contents:

Index Topics: Reviews: Errata: Reader Comments: