Oracle Database 12c R2: New Features for 12c R1 Administrators (D93517) – Outline

Detailed Course Outline

Introduction
  • Global objectives of the course
  • Lessons grouped by area
  • Schedule of the week
Application Containers and Applications
  • Application root and application PDBs
  • Create and manage an application container
  • Install application in an application container
  • Patch application
  • Upgrade application
  • Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map
Security in PDBs
  • Create users commonly, locally in application containers
  • Grant privileges commonly, locally in application containers
  • Difference between common and local roles in application containers
  • Grant roles commonly, locally in application containers
  • Difference between common and local objects in application containers
  • Difference between common and local profiles in application containers
  • Manage PDB lockdown profiles
  • Create unified auditing policies operations in application containers
PDBs Creation Using New Methods
  • Create a PDB from CDB seed enhancements
  • Unplug into a PDB archive file and plug using the archive file
  • Create a local UNDO tablespace at PDB level
  • Hot cloning
  • Near-zero downtime PDB relocation
  • Create a remote proxy PDB
PDBs Recovery and Flashback
  • Shut down a PDB when an essential PDB datafile is missing
  • Flashback at PDB level
  • Flashback a PDB to a clean PDB restore point
Performance in PDBs
  • View CDB / PDB ADDM analysis
  • Manage SGA and PGA at the PDB level
  • Share resources between PDBs
Upgrade and Other Operations in PDBs
  • Upgrade a 12.1.0.2 CDB to 12.2
  • Upgrade a 12.1.0.2 PDB to 12.2 by using unplug / plug / upgrade
  • Use cross-platform non-CDB or PDB backupsets to import into a CDB
Privileges and User Profiles
  • New 12.2 SYSRAC administrative privilege
  • Password file enhancements
  • Grant administrative privileges to external users
  • Migrate the password file from pre-12 or 12.1 to 12.2
  • New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
  • Enhance the security of administrative users
  • Pre-configure a maximum number of days in the user profile for which a user can remain inactive
Unified Auditing
  • Create and enable audit policies for all users to whom the role is granted directly
  • Capture VPD (Virtual Private Database) generated predicates
Data Redaction
  • New redaction format library in EM GUI
  • Redaction policy expression
  • New redaction functions
Data Encryption
  • Encrypt / decrypt / rekey tablespaces online
  • Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary
  • Complete the operations with ALTER TABLESPACE ENCRYPTION FINISH ENCRYPT|REKEY|DECRYPT
Transparent Sensitive Data Protection
  • Use TSDP with Unified Auditing
  • Use TSDP with Fine-Grained Auditing (FGA)
  • Use TSDP with Transparent Data Encryption (TDE)
Availability Enhancements
  • Non auto-login support for duplicate: Use encrypted backups whose decryption keys are in a non auto-login wallet
  • Update and drop the catalog without entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / DROP CATALOG NOPROMPT
  • Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Recover Database Until Available Redo
  • REPAIR FAILURE command
  • Transport Data Across Platforms
  • Steps to recover a table
  • Describe online redefinition supports
Oracle Data Pump, SQL*Loader and External Tables
  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • External table enhancements
In-Memory Column Store
  • Dynamic parameter in 12.2 : INMEMORY_SIZE
  • Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
  • Optimizing joined columns by creating join groups
  • Interaction with other products, features
SQL Tuning
  • SQL Performance Analyzer enhancements
  • SQL Plan Management enhancements
  • Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
  • SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
  • New ways of SQL processing
  • Continuous Adaptive Query Plans
Resource Manager and Other Performance Enhancements
  • Manage session PGA limit
  • Reduce Cursor Invalidations for DDLs
  • Describe the Advanced Index Compression (HIGH)
  • Define real-time materialized views with on query computation
  • Use ON STATEMENT refresh when a DML operation takes place on materialized views without the need to committhe transaction
  • Describe HCC data compression with ADO row-level policy
Partitioning
  • Explain auto-list partitioning
  • Composite partitioning
  • Explain multicolumn list partitioning
  • Read-only partition
  • Defer subpartition segment creation
  • Filter data during partition maintenance operations
Manageability
  • Start / stop a DBOP by specifying the Session ID and Serial#
Diagnosability
  • Set a retention target to ADR for an automatic delete of ADR files
  • Use the retention advisor
  • Install TFA Collector by default for RDBMS (with RDBMS root scripts)
  • Start TFA Collector
  • Allow Data Pump tracing to be changed without stopping and then restarting the job
  • MV refresh statistics
Oracle Database Cloud Services
  • Describe the Oracle Database Cloud Services console
  • Create a database deployment under 12.2
  • Database deployment backup and recovery automatic procedures
  • Differences between database deployments and on-premises databases
  • Migrate on-premises database to Oracle Database Public Cloud Services
SQL Enhancements
  • Describe the new SQLcl utility
  • Use new 128 bytes length for database objects
  • Recall SQL*Plus commands in the same session from memory
  • Use the new VALIDATE_CONVERSION function