Oracle 12c New Features training course

Management tools new features

      SQL Developer DBA connections

      Database Express

      Cloud Control

      SQL*plus new features (not many!)

      Recovery Manager new features 

      Datapump           view as tables export/import

                         Transportable tablespace new features

      SQL*Loader Express Mode

     

Multi-tenant databases:

      when to adopt,

      how to set up (command line (little))  dbca,

      how to populate 

               (dbca, dbexport, command line)

               (moving non-cdbs to cdb)

      basic administration 

(command line, Database Express, SQL Developer DBA   connections, Cloud control)

      backing up and recovering,

      taking AWR/ASH reports from

      local vs root level culture/approaches/issues

      Resource Manager share management

 

Oracle database architecture new features        

      Automatic Data Repository (ADR) DDL Logging

      Temporary undo management

      PGA aggregate limit approach

      Smart Cache management new features

      New background processes

      New listener options

      Optional Linux/Unix multi-threaded architecture

      Extended data types

 

Security management new features:

      Unified auditing approach

      SYSBACKUP, SYSDG, SYSKM

      Privilege behaviour analysis

      Data redaction policy approach

     

Data management:

      New advanced compression features

      Moving data inline

      Information Life Cycle policies

(Using heat map and Automatic Data Optimization)

      Table and index new features     

 

SQL new features:

      Same column/multi index support

      Identity columns

      Extended string length support

      Extended inline movement support for tables,partitions,  indexes

      Multi-partition management (e.g. mult-partition split, merge,move )

      Partition table partial index coverage

      PL/SQL integration with SQL (extension to WITH)

      DBMS Redefinition new features

      Hybrid and Top Frequency histograms

     

Performance management:

      Taking AWR and ASH reports

      Resource Manager new features for PDB and non PDB

      In-database archiving

      Temporal Validity vs Temporal History

      Optimizer plan management new features

               (including adaptive plans (dynamic and plan reoptimization)

      Working with adaptive cursor new features

      Working with SQL Plan baselines new features

      New graphical tool support for AWR, ASH, ADDM

      Improved quality ADDM analysis

( Hybrid and Top Frequency histograms )

SQL Directives