Book description
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
Table of contents
- Cover
- Title Page
- Copyright Page
- About the Authors
- Contents at a Glance
- Contents
- Foreword
- Acknowledgments
- Introduction
-
Chapter 1: Getting Started with Oracle Database 12c
- Downloading and Staging Oracle Database 12c
-
Preparing to Install Oracle Database 12c
- Review the Install Guides and Read-Me 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 Whether Any Patches Are Required Prior to the Install
- Finish the Pre-Install Steps
- Installing and Deinstalling Oracle Database 12c
- The Death of Database Control and Birth of Database Express
- Accessing Database Express
- End of Line
-
Chapter 2: Upgrading and Migrating to Oracle Database 12c
- Introductory Comments
- New Features Related to Upgrading to Oracle Database 12c
- Preparing for an Upgrade to Oracle Database 12c
- Upgrading to Oracle Database 12c with the Database Upgrade Assistant
- Upgrading to Oracle Database 12c Manually
- Migrating to Oracle Database 12c with Oracle Data Pump
- Rolling Back the Upgrade
- Miscellaneous Changes to Be Aware of After Upgrading
- End of Line
- Chapter 3: Oracle Multitenant
- Chapter 4: Oracle Grid Infrastructure
- Chapter 5: Backup, Recovery, and Data Guard New Features
-
Chapter 6: Oracle Database 12c SQL and PL/SQL New Features
- Oracle Database 12c DML New Features
-
Oracle Database 12c DDL New Features
- Increased Size Limits for VARCHAR2, NVARCHAR2, and RAW Data Types
- Identity Columns
- Cascading Truncate Statements
- Invisible Columns
- Default Values for Columns Based on Oracle Sequences
- Default Values for Columns on Explicit NULL Insertion
- Sequence-Related New Features
- Creating Multiple Indexes on the Same Column Set
- With Clause New Features
-
Oracle Database 12c PL/SQL New Features
- Using the Bequeath Clause on Views
- PL/SQL Subprogram White Lists
- Using PL/SQL-Specific Data Types Across the PL/SQL-to-SQL Interface
- Changes to Security Privileges on Invoker Rights PL/SQL Program Units
- Granting Roles to PL/SQL Packages and Stand-Alone Subprograms
- A Final Word on PL/SQL New Features
- End of Line
- Chapter 7: Partitioning Enhancements
- Chapter 8: Business Intelligence and Data Warehousing
- Chapter 9: Security New Features
- Chapter 10: Oracle Database 12c Manageability New Features
-
Chapter 11: Oracle Database 12c Performance New Features
-
Statistics-Related New Features
- Automatic Column Group Detection
- Concurrent Statistics Gathering
- Enhancements to Incremental Statistics
- Online Statistics Gathering for Bulk Loads
- Session-Private Statistics for Global Temporary Tables
- Running Statistics Gathering Options in Reporting Mode
- Reports on Past Statistics Collection Operations
- Optimizer-Related New Features
- End of Line
-
Statistics-Related New Features
-
Chapter 12: Other Oracle Database 12c New Features
-
Data Pump Export and Import New Features
- The views_as_tables Parameter
- Moving Databases Across Platforms, Regardless of Byte Format, with Transportable Tablespaces
- Transform Clause New Features
- Data Pump Fully Supports Oracle’s New Multitenant Database Technologies
- Enable Unified Auditing for Data Pump Jobs
- Miscellaneous Enhancements to Data Pump
- Oracle SQL*Loader Enhancements
- Oracle External Table Enhancements
- Oracle Log Miner Enhancements
- ADR DDL and Debug Logs
- Oracle SecureFiles Enhancements
- Oracle R Enterprise, Hadoop, and MapReduce
- CloneDB
- SQL Translation Framework
- End of Line
-
Data Pump Export and Import New Features
- Appendix A: Deprecated and Desupported Features in Oracle Database 12c
- Appendix B: New Parameters and Views in Oracle Database 12c
- Index
Product information
- Title: Oracle Database 12c New Features
- Author(s):
- Release date: December 2013
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071799324
You might also like
book
Oracle Database 12c Release 2 New Features
Leverage the New and Improved Features of Oracle Database 12c Written by Oracle experts Bob Bryla …
video
Oracle 12c New Features, Part I LiveLessons
4+ Hours of Video Instruction Overview In the wake of the release of Oracle Database 12 …
book
Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2
Learn all of the available upgrade and migration methods in detail to move to Oracle Database …
book
Oracle RMAN Database Duplication
RMAN is Oracle’s flagship backup and recovery tool, but did you know it’s also an effective …