Adaptive Plans in Oracle Database 12c Release 1 (12.1) - See how the 12c optimizer uses adaptive plans to adjust execution plans on the fly.
Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1) - This article provides links to articles on the individual features of Adaptive Query Optimization.
Adaptive SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1) - Check out the changes to SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1).
Administrative Privileges and Job Role Separation in Oracle Database 12c Release 1 (12.1) - Oracle 12c includes additional administrative privileges to allow a greater level of job role separation if that is necessary in your organisation.
Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1 - Oracle 12c can optimize the performance of some DROP PARTITION and TRUNCATE PARTITION commands by deferring the associated index maintenance, while leaving the global indexes in a valid state.
Auditing Enhancements (Unified Audit Trail) in Oracle Database 12c Release 1 (12.1) - The introduction of audit policies and the unified audit trail simplifies the configuration of database auditing in Oracle 12c.
Automatic Column Group Detection in Oracle Database 12c Release 1 (12.1) - This article describes how necessary extended statistics for column groups are identified automatically in Oracle Database 12c Release 1.
Automatic Database Diagnostic Monitor (ADDM) Compare Period in Oracle Database 12c Release 1 (12.1) - Oracle database 12c now allows you to compare periods of activity at database or instance level using the DBMS_ADDM package.
Automatic Diagnostics Repository (ADR) Enhancements in Oracle Database 12c (ADRCI) - This article describes the enhancements to ADR in Oracle Database 12c.
Automatic Reoptimization in Oracle Database 12c Release 1 (12.1) - See how statistics feedback and performance feedback are used by automatic reoptimization in Oracle Database 12c Release 1.
Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE) in Oracle Database 12c Release 1 (12.1) - Use the DBMS_PRIVILEGE_CAPTURE package to capture privilege usage, helping you to identify unused privileges.
Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1 - The TRUNCATE [SUB]PARTITION and EXCHANGE [SUB]PARTITION commands can now include a CASCADE clause, allowing the actions to cascade down the hierarchy of reference partitioned tables.
Concurrent Statistics Collection in Oracle Database 12c Release 1 (12.1) - Improve the speed of statistics collection from Oracle database 12c Release 1 onward.
Data Pump Enhancements in Oracle Database 12c Release 1 (expdp, impdp) - This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1.
Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1) - The Database Migration Assistant for Unicode (DMU) allows you to convert databases to use a unicode character set.
Database Smart Flash Cache in Oracle Database 12c Release 1 - Learn how to configure and use the Database Smart Flash Cache in Oracle Database 12c Release 1.
Data Redaction (DBMS_REDACT) in Oracle Database 12c Release 1 (12.1) - Use data redaction to protect sensitive data in Oracle Database 12c Release 1 (12.1).
Dynamic Statistics in Oracle Database 12c Release 1 (12.1) - This article describes the changes made to dynamic sampling in Oracle Database 12c Release 1 (12.1).
Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c - Get diagnostics information from hung databases using the Emergency Monitoring feature of Oracle Enterprise Manager Cloud Control 12c.
Enterprise Manager Database Express in Database 12c Release 1 - An overview of Database Express in Oracle Database 12c Release 1.
Extended Data Types in Oracle Database 12c Release 1 (12.1) - Ease the migration of applications from other database engines to Oracle 12c by using extended data types.
External Table Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to external tables in Oracle Database 12c Release 1 (12.1).
Flashback Data Archive (FDA) Enhancements in Oracle Database 12c Release 1 (12.1) - Check out the latest enhancements to flashback data archive (FDA) in Oracle Database 12c Release 1 (12.1).
Histogram Enhancements in Oracle Database 12c Release 1 (12.1) - Two new types of histogram have been added and one of the existing types has been de-emphasised in Oracle Database 12c Release 1.
In-Database Archiving in Oracle Database 12c Release 1 (12.1) - Use the in-database archiving functionality to implement "mark for delete" functionality out-of-the-box.
Index Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to index enhancements in Oracle Database 12c Release 1
Interval-Reference Partitioning in Oracle Database 12c Release 1 - Oracle 12c allows you to use an interval partitioned table as the parent for a reference partitioned table.
Multiple Indexes on the Same Set of Columns in Oracle Database 12c Release 1 - Oracle 12c allows multiple indexes on the same set of columns, provided only one index is visible and all indexes are different in some way.
Multitenant : Overview of Container Databases (CDB) and Pluggable Databases (PDB) - This article provides a basic overview of the multitenant option, with links to more detailed articles on the functionality.
Multitenant : Create and Configure a Container Database (CDB) in Oracle Database 12c Release 1 (12.1) - Take your first steps with the Oracle Database 12c Multitenant option by creating container databases.
Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Take your next steps with the Oracle Database 12c Multitenant option by creating pluggable databases.
Multitenant : Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Learn now to start converting your existing regular databases into pluggable databases in Oracle Database 12c Release 1 (12.1).
Multitenant : Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article explains how to connect to container databases (CDB) and pluggable databases (PDB) on Oracle 12c Release 1 (12.1).
Multitenant : Startup and Shutdown Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Learn how to startup and shutdown container databases (CDB) and pluggable databases (PDB) in Oracle 12c Release 1 (12.1).
Multitenant : Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article shows how to configure instance parameters and modify the database for container databases (CDB) and pluggable databases (PDB) in Oracle Database 12c Release 1 (12.1).
Multitenant : Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - This article demonstrates how to manage tablespaces in a container database (CDB) and pluggable database (PDB) in Oracle Database 12c Release 1 (12.1).
Multitenant : Manage Users and Privileges For Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - This article shows how to manage users and privileges for container databases (CDB) and pluggable databases (PDB) in Oracle Database 12c Release 1 (12.1).
Multitenant : Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Learn how backup and recovery is affected by the multitenant option in Oracle Database 12c Release 1 (12.1).
Multitenant : Flashback of a Container Database (CDB) in Oracle Database 12c Release 1 (12.1) - Identify the restrictions when using flashback database against a container database (CDB) in Oracle 12c.
Multitenant : Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Control resource allocation between pluggable databases and within an individual pluggable database.
Multithreaded Model using THREADED_EXECUTION in Oracle Database 12c Release 1 (12.1) - Learn how to switch the database between the multiprocess and multithreaded models in Oracle Database 12c Release 1 (12.1).
Online Move Datafile in Oracle Database 12c Release 1 (12.1) - Rename and relocate datafiles with no downtime in Oracle Database 12c Release 1 (12.1).
Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1 - In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.
Online Operation Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle database 12c includes a number of new online operations.
Online Statistics Gathering for Bulk Loads in Oracle Database 12c Release 1 (12.1) - See how Oracle 12c can automatically gather statistics for some bulk operations.
Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1 - Oracle 12c allows the creation of global and local indexes on a subset of the partitions of a partitioned table.
Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1 - In Oracle 12c some maintenance operations can now be performed on multiple partitions in a single
ALTER TABLE statement.Partitioning Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.
Real-Time Automatic Database Diagnostics Monitor (ADDM) in Oracle Database 12c Release 1 (12.1) - Get up-to-the-minute analysis from ADDM, rather than waiting for the next AWR snapshot.
Real-Time Database Operation Monitoring in Oracle Database 12c Release 1 - Oracle 12c extends real-time SQL monitoring to allow monitoring of multiple SQL and PL/SQL calls as a single operation.
Recovery Manager (RMAN) Enhancements in Oracle Database 12c Release 1 (12.1) - This article described the new features and enhancements made to Recovery Manager (RMAN) in Oracle Database 12c Release 1 (12.1).
Recovery Manager (RMAN) Database Duplication Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements made to Recovery Manager (RMAN) for database duplication in Oracle Database 12c Release 1 (12.1).
Recovery Manager (RMAN) Table Point In Time Recovery (PITR) in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c makes Point In Time Recovery (PITR) of individual tables as easy as a single Recovery Manager (RMAN) command.
Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.1).
Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1) - Simplify the syntax of Top-N queries using the row limiting clause of Oracle Database 12c.
Session-Private Statistics for Global Temporary Tables in Oracle Database 12c Release 1 (12.1) - This article explains the role of SQL Plan Directives in Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1).
SQL Plan Directives in Oracle Database 12c Release 1 (12.1) - This article explains the role of SQL Plan Directives in Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1).
SQL*Loader Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to SQL*Loader in Oracle Database 12c Release 1 (12.1).
Statistics Collection Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together links to all the statistics collection enhancements in Oracle Database 12c Release 1.
Table Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to table enhancements in Oracle Database 12c Release 1
Temporal Validity in Oracle Database 12c Release 1 (12.1) - Make querying of effective date ranges simpler using temporal validity in Oracle database 12c.
Oracle Database 12c Release 1: Miscellaneous Articles
APPROX_COUNT_DISTINCT : Quick Distinct Count in Oracle Database 12cR1 (12.1.0.2) - Use the APPROX_COUNT_DISTINCT to get quick counts of distinct values in 12.1.0.2 onward.Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) - Discover how Oracle Database 12c allows you to grant roles directly to PL/SQL program units.
Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES) - Learn how to plug security holes related to invoker rights PL/SQL code in Oracle Database 12c Release 1.
Control Invoker Rights Privileges in Views in Oracle Database 12c Release 1 (12.1) (BEQUEATH CURRENT_USER) - This article describes support for invoker rights function calls in views in Oracle Database 12c Release 1.
DBMS_COMPRESSION Enhancements in Oracle Database 12c Release 1 (12.1.0.2) - Check out the enhancements to the DBMS_COMPRESSION package in Oracle Database 12c Release 1 (12.1.0.2).
DBMS_UTILITY.EXPAND_SQL_TEXT : Expand SQL References to Views in Oracle Database 12c Release 1 (12.1) - Easily display the true complexity of SQL statements that reference views.
DEFAULT Values for Table Columns : Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the changes to table column defaults in Oracle Database 12c.
Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1) - Learn how to create non-editionable objects in edition-enabled schema.
Fine-Grained Access to Network Services Enhancements in Oracle Database 12c Release 1 - Take control of the external services accessed by the
UTL_TCP, UTL_INADDR, UTL_HTTP, UTL_SMTP, and UTL_MAIL packages.Full Database Caching Mode in Oracle Database 12cR1 (12.1.0.2) - Learn how changes in Oracle Database 12cR1 (12.1.0.2) affect the way Oracle handles the buffer cache.
Identity Columns in Oracle Database 12c Release 1 (12.1) - Replace trigger-based population of numeric ID columns with the new identity functionality in Oracle Database 12c Release 1.
Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT) - Implicit statement results will simplify the migration of stored procedures from other database engines to Oracle 12c onward.
In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of the In-Memory Column Store feature in Oracle 12c Release 1 (12.1.0.2).
Invisible Columns in Oracle Database 12c Release 1 (12.1) - Oracle database 12c allows columns to be created or modified to make them invisible.
JSON Support in Oracle Database 12c Release 1 (12.1.0.2) - This article describes the server side support for JSON in the database.
Indexing JSON Data in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of how to index JSON data in Oracle Database 12c Release 1 (12.1.0.2).
LATERAL Inline Views, CROSS APPLY and OUTER APPLY Joins in Oracle Database 12c Release 1 (12.1) - Learn the new variations on inline views and joins available in Oracle 12c.
Multitenant : Clone a Remote PDB or Non-CDB in Oracle Database 12c (12.1.0.2) - Clone PDBs from remote PDBs and Non-CDBs over database links in Oracle Database 12c (12.1.0.2).
Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1) - With the introduction of the multitenant option, database event triggers can be created in the scope of the CDB or PDB.
Multitenant : PDB Logging Clause in Oracle Database 12c Release 1 (12.1.0.2) - The PDB logging clause is used to set the default tablespace logging clause for a PDB in Oracle Database 12c Release 1 (12.1.0.2).
Multitenant : Metadata Only PDB Clones in Oracle Database 12c Release 1 (12.1.0.2) - Make structure-only copies of PDBs using the
NO DATA clause added in Oracle Database 12c Release 1 (12.1.0.2).Multitenant : PDB CONTAINERS Clause in Oracle Database 12c Release 1 (12.1.0.2) - The PDB CONTAINERS clause allows data to be queried across multiple PDBs in Oracle Database 12c Release 1 (12.1.0.2).
Multitenant : PDB Subset Cloning in Oracle Database 12c Release 1 (12.1.0.2) - Use subset cloning to limit the amount of tablespaces you bring across to your new PDB.
Multitenant : Pluggable Database (PDB) Names - A brief article to highlight the importance of unique PDB names.
Multitenant : Pluggable Databases - What they will break and why you should use them anyway! - This article identifies the type of problems you will encounter when moving to the multitenant architecture.
Multitenant : Remove APEX Installations from the CDB in Oracle Database 12c Release 1 (12.1) - This article describes how to remove APEX from the CDB so you can install it directly in a PDB.
Multitenant : Upgrade a PDB using Unplug/Plugin - This article describes the method for upgrading a PDB using the unplug/plugin method.
Multitenant : Running Scripts in Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1) - This article presents a number of solutions to help transition your shell scripts to work with the multitenant option.
Multitenant : Transparent Data Encryption (TDE) in Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1) - This article describes some of the basic key management operations as they relate to Transparent Data Encryption (TDE) in Oracle Database 12c Release 1.
Oracle Database File System (DBFS) Enhancements in Oracle Database 12c Release 1 (12.1) - Access your DBFS file systems via HTTP/HTTPS, FTP and WebDAV in Oracle Database 12c Release 1.
Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c Release 1 (12.1) - Learn about the new pattern matching analytic function clause available in Oracle 12c onward.
PL/SQL New Features and Enhancements in Oracle Database 12c Release 1 - Learn about the new features and enhancements to PL/SQL in Oracle 12c Release 1.
PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1) - Oracle 12c now supports the binding of additional PL/SQL-only data types to SQL.
PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) - Use the ACCESSIBLE BY clause to create white lists, adding an extra layer of security to your PL/SQL objects.
READ Object Privilege in Oracle Database 12c Release 1 (12.1.0.2) - Use the READ object privilege to create read-only users that no longer have the ability to lock rows in the tables they query.
Session Sequences in Oracle Database 12c Release 1 (12.1) - Use sequences whose current value is not persisted between sessions in Oracle database 12c Release 1 (12.1).
Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c Release 1 adds more functionality to the Oracle scheduler.
Temporary Undo in Oracle Database 12c Release 1 (12.1) - Place undo segments for global temporary tables in the temporary tablespace in Oracle Database 12c Release 1 (12.1).
TRUNCATE TABLE ... CASCADE in Oracle Database 12c Release 1 (12.1) - This article discusses the TRUNCATE TABLE ... CASCADE functionality in Oracle Database 12c Release 1. (12.1).
Upgrading to Oracle Database 12c - This article provides an overview of some of the options for upgrading existing databases to Oracle 12c Release 1.
Using the TABLE Operator with Locally Defined Types in PL/SQL - In Oracle 12c, the TABLE operator can now be used in PL/SQL with locally defined types.
UTL_CALL_STACK : Get Detailed Information About the Currently Running Subprogram in Oracle Database 12c Release 1 (12.1) - Display information about call stack and error stack for PL/SQL subroutines using the UTL_CALL_STACK package.
WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) - Define PL/SQL functions and procedures in the WITH clause of SQL statements.
The following blog posts talk about other features available in Oracle Database 12c.
Tom’s Top 12 Things About the Latest Generation of Database Technology - Notes about Tom Kyte's Oracle OpenWorld 2012 presentation.
Oracle Database Optimizer: An Insider’s View of How the Optimizer Works - Notes about Maria Colgan's Oracle OpenWorld 2012 presentation.
What’s New in Security in the Latest Generation of Database Technology - Notes about Tom Kyte's Oracle OpenWorld 2012 presentation.
