Description

This seminar offers you an overview of the new features of the Oracle 12c DBMS. Topics covered include multi-tenant architecture, automatic data optimization, real-time database diagnostics, adaptive execution plans, and obfuscation protection.

Who is this training for ?

For whom ?

Oracle database administrators, developers, consultants, project managers and application managers who want to think about upgrading their databases to version 12c.

Prerequisites

Training objectives

Evaluate the new features offered by the Oracle database version 12c.

Judge Oracle's efforts regarding Cloud Computing and virtualization

Evaluate the advantages and opportunities brought by Oracle version 12c.

Training program

• Enterprise Manager and other tools
  • EM Cloud Control et Database Express.
  • OUI et DBCA.
  • SQL Developer.
• Shared architecture
  • Root container (CDB).
  • Inserted containers (PDB).
  • Manage logs, flashbacks and tablespaces.
  • Manage common/local schemas, privileges, and roles.
  • Create or clone a PDB insert database.
  • Extracting a PDB insert database from a container and insertion into another.
  • Connections to inserted PDB databases.
  • Manage tablespaces, users, privileges, common/local roles.
• Backup and Restore
  • The new SYSBACKUP and SYSDG privileges.
  • The use of SQL in RMAN.
  • Multisection backups.
  • Transport between platforms .
  • Saving, duplicating and flashback.
• Automatic data optimization
  • Analysis of database activity.
  • Automatic movement and compression.
  • Types of compression and strategies.
  • The archiving solution in the database.
  • Manage temporal and historical validity.
• Audit, monitoring, diagnosis
  • Setting up and managing the unified audit.
  • Monitor a BDD ADDM operation in real time.
  • Define the dimensions of the overall load .
  • ADR repository and network enhancements.
  • Handle resources and blocked requests.
  • Changes to shutdown procedures.
  • Active database operation report.
• Privileges
  • Implement segregation of duties.
  • Use database privilege scanning.
  • Ombre protection.
  • Security policies masking.
• The diagrams
  • Schema editing and synchronization.
  • The data comparison flow.
  • Multiple indexes on the same set of columns.
  • Create a table with invisible columns.
  • Advanced row compression.
  • Redefinition and inline modifications.
  • Partitioned tables.
• SQL queries
  • The new data types.
  • The row limitation clause.
  • Handling adaptive execution plans.
  • Improvements in collecting statistics.