Отримати консультацію
Training Center MUKКурсыOracleDatabaseOracle Database 12c R2: New Features for Administrators Part 1 Ed 1

Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

Код курсу
5 Днів, 40 Ак. Годин
Опис курсу
Програма курсу
Опис курсу

Course overview

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.


Course Objectives

  • Create and manage pluggable databases
  • Describe the challenges and benefits of a sharded database
  • Handle the ADR automatic file space
  • Diagnose database issues by using the Trace File Analyzer collector
  • Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
  • Use the SQLcl new utility as the new SQL command line interface
  • Create and manage a multitenant container database

Suggested Prerequisite

  • Knowledge of Oracle Database 11g R2

Required Prerequisite

  • Oracle Database 12c: Install and Upgrade Workshop
  • Using Oracle Enterprise Manager Cloud Control 13c Ed 2


  • End Users
  • Database Administrators
  • Database Administrators
  • System Administrator
  • System Administrator
Програма курсу

Course Topics

1. Introduction

  • Understanding DB architectures
  • Diagnosing database problems
  • Global objectives of the course
  • Schedule of the week
  • Using SQL new features and tools
  • Lessons grouped by modules

2. Creating Application PDBs and Installing Applications

  • PDBs and applications
  • Application common objects
  • Create and manage an application container
  • Types of containers
  • Patch and upgrade applications
  • Regular PDBs vs application PDBs
  • Application containers
  • Install applications

3. Managing Security

  • Enabling Common Users to Access Data in PDBs
  • Encrypting data in PDBs
  • Creating common users, roles and profiles in CDB and PDBs
  • Protecting data with Database Vault policies in CDB and PDBs
  • Common objects in Application PDBs and operations on Data-Linked objects
  • Granting privileges commonly in CDB and PDBs
  • Auditing users in CDB and PDBs
  • Managing PDB lockdown profiles

4. Moving and Migrating Data

  • Transporting a database over the network
  • Exporting non-CDB data and importing non-CDB data into PDB
  • Using SQL*Loader with PDBs
  • Exporting and importing between PDBs
  • Exporting from PDB and importing into a non-CDB
  • Full Transportable export/import
  • Using Oracle Data Pump with PDBs

5. Diagnosing Database Problems

  • TFA Collector utility
  • Tracing Data Pump
  • New ADRCI Command
  • Automatic Diagnostic Repository
  • MVs refreshed statistics history
  • Trace File Analyzer (TFA) Collector process and repository
  • ADR Retention
  • Network Performance

6. Using SQL New Features and SQLcl

  • Use SQL row-limiting clause
  • Use new 128 bytes identifier length for database objects
  • Describe the support for invisible and hidden columns
  • Increase length limits of data types
  • Use the new VALIDATE_CONVERSION function
  • Recall SQL*Plus commands in the same session from history
  • Describe the new SQLcl utility

7. Creating PDBs

  • Cloning regular and application containers PDBs
  • Converting regular PDBs to application root or PDBs
  • Cross-Platform transportable PDB
  • Plugging unplugged regular and application PDBs into CDB
  • Plugging unplugged PDBs with encrypted data
  • Perform hot cloning and relocation
  • Configure and use locla UNDO mode
  • Plugging or cloning a non-CDB into a CDB

8. acking up, Recoverying and Flashing Back

  • Instance failure and instance recovery
  • CDB and PDB backups
  • PDB point-in-time recovery
  • New syntax and clauses in RMAN
  • PDB tempfile, essential and non-SYSTEM tablespaces recovery
  • CDB and PDB flashback
  • Duplicating PDBs
  • Using RMAN backup to plug an unplugged PDB

9. Performing Miscellaneous Operations

  • Using catcon.pl utility to install/remove options from CDB/PDB
  • Jobs coordinator and resources
  • Creating a standby of a CDB
  • Using Xstreams with a CDB and PDB
  • Mining statements of a PDB using LogMiner
  • Scheduling operations in a PDB

10. Understanding CDB Basics

  • Challenges
  • Configurations
  • CDB root and pluggable database containers
  • SYSTEM objects in the USER container
  • New Multitenant Architecture: Benefits
  • Non-CDB Architecture vs Oracle Multitenant Container Database
  • A pristine installation
  • Provisioning a pluggable database

11. Creating CDB and Regular PDBs

  • Tools
  • Create a CDB using new clauses
  • What’s new in CDB after CDB creation
  • ADR
  • Data dictionary views
  • Provisioning new PDBs: overview
  • What to do in CDB after CDB creation

12. Managing CDB and PDBs

  • Creating and renaming Services
  • Switching Connection
  • Opening CDBs and PDBs
  • Managing CDB and PDBs
  • Mounting a CDB
  • Evaluating the impact of parameter value changes
  • Changing the different modes and settings of PDBs
  • Starting Up a CDB Instance

13. Managing Storage

  • Creating Permanent Tablespaces in a CDB
  • Objects in Tablespaces
  • UNDO Tablespaces
  • Tablespaces Created During PDB Creation
  • Temporary Tablespaces
  • Defining Default Permanent Tablespaces

14. Managing Performance

  • Monitoring PDB memory usage
  • AWR report
  • Managing SGA and PGA for PDBs
  • Controlling the Degree of Parallelism of Queries
  • PDB-Level snapshot views
  • AWR and ADDM behaviour at CDB and PDB levels
  • Sizing the CDB
  • Tuning a CDB

15. Managing Resources Allocation

  • Controlling PDB IO rate limit
  • Managing resources within a PDB
  • CDB Resource plan basics: Limits + cpu_count init parm per PDB
  • Creating and setting PDB performance profiles
  • Allocating resources in the CDB and PDBs
  • Managing resources between PDBs

16. Understanding Database Sharding

  • Benefits of Sharding
  • Advantages of Oracle Sharding over NoSQL
  • Creating Sharded Tables
  • Sharded Table Family
  • What Is Database Sharding?
  • Application Considerations for Sharding
  • Components of Database Sharding
  • Complete Deployment of a System-Managed SDB
Реєстрація на найближчий курс
Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
Код курсу:
5 Днів, 40 Ак. Годин
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.