Oracle Database 12c R2: New Features for 12c R1 Administrators

Learn the new and enhanced features of Oracle Database 12c Release 2 ( amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL.


We are sorry, but currently we don't know when the course will be arranged next time.
Please contact sales: +358 20 7776 670 or

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.

Learn To

Create and manage application containers and applications in multitenant container databases.

Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.

Perform pluggable database flashback.

Upgrade the multitenant container databases and pluggable databases.

Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.

Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.

Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.

Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.

Monitor your databases by using DB operations enhancements.

Benefit from enhancements in partitioning methods.

Benefit from ADR automatic space file management.

Use the Trace File Analyzer collector to diagnose issues.

Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.

Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.

Describe the Oracle Public Cloud services related to databases management.

You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.

Check more detailed course description here.

Target audience

Database Administrators

Support Engineer

System Administrator

Technical Consultant


Knowledge of Oracle Database 12c and particularly

Oracle Database 12c R1: New Features for Administrators Ed 2


Hectic schedule and need flexible learning options? Choose a training that fits best your learning style and schedule. To hear more about virtual and self-paced training formats, please contact Personal Customer Service or through chat-service.



Keywords: , ,


Places left:
No participant limit
3555,00  + VAT

Responsible person

Eine Lahtisalo

Eine Lahtisalo

Eine is a Microsoft Office specialist, who has worked as a full-time trainer for over 15 years. She has been involved in planning numerous customized training projects and has operated as a responsible trainer in many Office-migration projects. As an enthusiastic learner herself, she has studied human resource management, business administration and project management alongside working.

Competence: Microsoft Certified Trainer (MCT), MOS Master-level, MCAS for Excel, Outlook, PowerPoint and Word, IPMA Level D – Certified Project Management Associate, ITIL Foundation 2011 Edition, Microsoft Office specialist.