Upgrade to Oracle Database 12c

New Features of Oracle Database 12c

Enterprise Manager and Other Tools

Use EM Express
Use OUI, DBCA for installation and configuration

Basics of Multitenant Container Database (CDB)

Identify the benefits of the multitenant container database
Explain root and multitenant architecture

Configuring and Creating CDBs and PDBs

Create and configure a CDB
Create and configure a PDB
Migrate a non-CDB to a PDB database

Managing CDBs and PDBs

Establish connection to a CDB/PDB
Start up and shut down a CDB/PDB
Change instance parameters for a CDB/PDB

Managing Tablespaces, Common and Local Users, Privileges and Roles

Manage tablespaces in a CDB/PDB
Manage users and privileges for CDB/PDB

Backup, Recovery and Flashback for a CDB/PDB

Perform backup of CDB and PDB
Perform recovery of CDB and PDB
Perform Flashback for a CDB

Information Lifecycle Management and Storage Enhancements

Use ILM features
Perform tracking and automated data placement
Use Online Move Datafile

In-Database Archiving and Valid-Time Temporal

Differentiate between IL and Valid-Time Temporal
Set and use Valid Time Temporal
Use In-Database archiving


Enable and configure Unified Audit Data Trail
Create and enable audit policies


Use administrative privileges
Create, enable and use privilege analysis

Oracle Data Redaction

Use and manage Oracle Data Redaction policies

RMAN and Flashback Data Archive

Use RMAN enhancements
Implement the new features in Flashback Data Archive

Real-Time Database Operation Monitoring

Implement real-time database operation monitoring

SQL Tuning

Use Adaptive Execution Plans
Use enhanced features of statistics gathering
Use Automatic SQL Plan Management

Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics

Perform emergency monitoring and real-time ADDM
Generate ADDM Compare Period
Diagnose performance issues using ASH enhancements

Resource Manager and Other Performance Enhancements

Use Resource Manager for a CDB and PDB
Explain Multi-process Multi-threaded Oracle architecture
Use Flash Cache

Index and Table Enhancements

Use Index enhancements
Use Table enhancements
Use Online operation enhancements

ADR and Network Enhancements

Explain ADR enhancements

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

Use Oracle Data Pump enhancements
Use SQL*Loader and External table enhancements

Partitioning Enhancements

Explain Partitioning enhancements
Explain Index enhancements for partitioned tables

SQL Enhancements

Use Oracle Database Migration Assistant for Unicode
Use Row limiting clause, and secure file LOBs enhancements
Configure extended datatypes

Key DBA Skills

Core Administration

Explain the fundamentals of DB architecture
Install and configure a database
Configure server and client network for a database
Monitor database alerts
Perform daily administration tasks
Apply and review patches
Back up and recover the database
Troubleshoot network and database issues
Detect and repair data failures with Data Recovery Advisor
Implement Flashback Technology
Load and Unload Data
Relocate SYSAUX occupants
Create a default permanent tablespace
Use the Redo Logfile Size Advisor
Use Secure File LOBs
Use Direct NFS

Performance Management

Design the database layout for optimal performance
Monitor performace
Manage memory
Analyze and identify performance issues
Perform real application testing
Use Resource Manager to manage resources
Implement Application Tuning


Manage database structures
Administer ASM
Manage ASM disks and diskgroups
Manage ASM instance
Manage VLDB
Implement Space Management


Develop and implement a security policy
Configure and manage auditing
Create the password file
Implement column and tablespace encryption

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.