Oracle Database 12c Release 2

Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information:

• Asynchronous Global Index Maintenance for Dropping and Truncating Partitions
• Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1
• ALTER INDEX COALESCE Clause
• DBMS_PART.CLEANUP_GIDX Procedure

Tom Kyte and Chuck Murray describe several improvements to default behavior in Oracle Database 12c: defaults based on sequences, default on NULL, Identity type columns, and metadata-only defaults. For more information:

• CREATE TABLE" statement in Oracle® Database SQL Language Reference
• ALTER TABLE" statement in Oracle® Database SQL Language Reference
• Identity Columns" in Oracle® Database Migration Guide

The demonstration provides an overview of the architecture of the In-Memory Column Store feature introduced in Oracle Database 12c Release 1 patchset 1.

Overview and demonstration of using the plsql_declarations clause to embed a PL/SQL function in a SQL SELECT statement.

• "plsql_declarations" in Oracle® Database SQL Language Reference

Overview and demo of using a unified audit policy to audit database behaviors, database components, and database users. 

• Monitoring Database Activity with Auditing" in Oracle Database Security Guide
• Auditing Database Activity" in Oracle Database 2 Day + Security Guide
• Keeping Your Oracle Database Secure" in Oracle Database Security Guide

Pagination queries using the row limiting clause to fetch N rows or a percentage of rows in a table. For more information, see

• Limiting SQL Rows
• row_limiting_clause

Tom Kyte discusses enhanced optimizer statistics followed by a demo of on-load statistics gathering in Oracle Database 12c.

• Online Statistics Gathering for Bulk Loads
• Histograms
• CREATE TABLE ... AS SELECT
• CREATE TABLE

Tom Kyte introduces adaptive execution plans followed by a demo.

• Adaptive Plans" in SQL Tuning Guide
• Controlling Adaptive Optimization
• Generating and Displaying SQL Execution Plans
• Keeping Your Database Secure

Tom Kyte introduces Oracle Multitenant in Oracle Database 12c followed by a demo showing: multitenant architecture, moving a pluggable database (PDB) from one multitenant container database (CDB) to another, cloning a PDB, and creating a new PDB. For more information:

• Multitenant Architecture" in Oracle® Database Concepts
• Managing a Multitenant Environment" in Oracle® Database Administrator's Guide
• About Common Users and Local Users" in Oracle® Database Security Guide

Demo of how to create a role using EM Express.

This video shows the steps for moving an online data file in Oracle Database 12c.

This video explains how to recover a pluggable database.

How to configure and Oracle Secure Backup 10.4 administrative domain using Oracle Enterprise Manager 11g Database Control.