Oracle database 12C : OCM Exam preparation Workshop Ed 1

Duration : 5 Days (40 Hours)

Oracle database 12C : OCM Exam preparation Workshop Ed 1 Course Overview:

The Oracle Database 12C OCM Exam preparation Workshop Ed 1 course provides comprehensive, comprehensive training on the primary topics of Oracle Database 12C certification, from basic certification knowledge to advanced configuration and optimization.
This course includes valuable hands-on sessions and assesses the skills and knowledge acquired through the practice sessions during the course. This course is the perfect preparation for the Oracle Database 12C OCP certification exam, as it covers all the objectives within the OCP syllabus. The workshop covers all aspects of the OCP preparation, including an introduction to the Oracle Database 12C version, understanding Oracle architecture, SQL and PL/SQL usage, database and server security, performance tuning, data replication, backup and recovery and more.
The course also provides practice exercises and test-taking strategies to help you maximize your OCP exam success. In addition, the instructor provides helpful advice on how to pass the test and answer the questions in the most effective way. The Oracle Database 12C OCM Exam preparation Workshop Ed 1 is suitable for individuals who are looking for a comprehensive and thorough preparation for the Oracle Database 12C OCP certification exam.

Intended Audience:

  • Database Administrators (DBAs) aspiring to become Oracle Certified Masters (OCMs)
  • Experienced DBAs preparing for the Oracle Database 12c OCM certification exam
  • IT Professionals seeking to enhance their skills and credentials in Oracle Database administration
  • Database Architects aiming to achieve the highest level of Oracle Database certification
  • Individuals who have already achieved Oracle Certified Professional (OCP) certification and are looking to progress to the OCM level
  • Professionals committed to achieving a comprehensive understanding of advanced Oracle Database concepts and practices as required by the OCM certification.

Learning Objectives of Oracle database 12C : OCM Exam preparation Workshop Ed 1:

The Oracle Database 12c OCM Exam Preparation Workshop Training is designed to empower participants to attain and demonstrate mastery-level competencies essential for successfully passing the Oracle Database 12c OCM exam. The primary objective of this training is to enhance participants’ proficiency in critical domains such as:

  1. Managing the Oracle Database and its Components
  2. Creating, Managing, and Manipulating Database Objects
  3. Configuring and Troubleshooting Oracle Database
  4. Understanding 12c Security Features
  5. Performance Management
  6. RMAN (Recovery Manager)
  7. Data Guard
  8. Database Maintenance

The training sessions are meticulously structured to foster the development of competencies outlined in the Oracle Database 12c OCM exam. Through comprehensive coverage of these domains, participants will be well-prepared to achieve their certification and demonstrate expertise in Oracle Database 12c administration and management.

 Module 1: Basics of Multitenant Container Database and Pluggable Databases

  • New Multitenant Architecture: Benefits
  • Multitenant Container Database
  • Separating SYSTEM and User Data
  • Provisioning a Pluggable Database
  • Interacting Within Multitenant Container Database
  • Multitenant Container Database Architecture
  • Common and Local Users
  • Common and Local Privileges and Roles

 Module 2: Managing Tablespaces and Users in CDB and PDBs

  • Tablespaces in PDBs
  • Creating Permanent Tablespaces in a CDB
  • Creating Local Temporary Tablespaces
  • Tablespace Encryption: Advantages
  • Creating an Encrypted Tablespac
  • Common and Local Schemas/Users
  • Granting and Revoking Privileges
  • Granting Common or Local Privileges/Roles to Roles

 Module 3: Basics of Parallel Execution

  • Parallelizable Operations
  • Previewing Execution Plans
  • Understanding Parallel Execution: Query Coordinator (QC) and Parallel (PX) Servers
  • Parallel Execution Plans: Identifying the Producers and Consumers
  • Parallel Execution Plans: Understanding Granules
  • Example PX Parameters
  • PX Parameters for Auto DOP
  • Parameters for PX Messaging: Shared and Large Pools

 Module 4: In-Memory Parallel Execution & Multi-Threaded architecture

  • Direct Reads Versus Buffer Cache Reads
  • Parallel Execution and the Buffer Cache
  • In-Memory Parallel Execution
  • When In-Memory Parallel Execution Works
  • Controlling In-Memory Parallel Execution
  • Enhance In-Memory PX Using Server Pools
  • Enhance In-Memory PX: Automatic Big Table Caching
  • Using PARALLEL_FORCE_LOCAL Parameter

 Module 5: Moving Data

  • Oracle Data Pump: Overview
  • Directory Objects for Data Pump
  • Data Pump Export and Import Clients: Overview
  • External Tables
  • Data Pump Import: Transformations
  • SQL*Loader: Overview
  • Loading Methods
  • Transportable Tablespaces

 Module 6: Working with Indexes

  • Normal B*-tree Indexes
  • Index Scans
  • Index Range Scan
  • Index Range Scan: Function-Based
  • Index Fast Full Scan
  • B*-tree Indexes and Nulls
  • Index-Organized Tables
  • Bitmap Indexes

 Module 7: Partitioning Concepts

  • Partitioned Tables and Indexes
  • Partitioning Strategies: Single-Level Partitioning
  • Oracle Partitioning History
  • Partition Key Extensions
  • Benefits of Partitioning: Table Availability
  • Manageability: Relocate Table Data
  • Benefits of Partitioning: Performance Considerations
  • Verifying Partition Use

 Module 8: Dataware House Tuning and Partitioning Workloads

  • Characteristics of a Data Warehouse
  • OLTP Systems Versus Data Warehouses
  • Data Warehouse Architectures: Basic Data Warehouse with Staging Area
  • Data Warehousing Objects
  • Optimizing Star Queries: Star Transformation
  • Execution Plan Without Star Transformation
  • Star Transformation Considerations
  • Retrieving Fact Rows from All Dimensions: Phase 1

 Module 9: Using Flashback Technologies

  • Flashback Technologies Error Detection and Correction
  • Flashback Technology
  • Guaranteeing Undo Retention
  • Flashback Query
  • Flashback Table: Overview
  • Flashback Table: Considerations
  • Flashback Transaction Query
  • Flashing Back a Transaction

 Module 10: Influencing the Optimizer

  • Functions of the Query Optimizer
  • Cardinality and Cost
  • Changing Optimizer Behavior
  • Optimizer Statistics
  • Optimizer Parameters
  • Enabling Query Optimizer Features
  • Dynamic Plans
  • Cardinality Feedback: Monitoring Query Executions

 Module 11: SQL Performance Management and SQL Data Compression

  • Maintaining SQL Performance
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Setting Statistic Preferences
  • Restoring Statistics
  • Deferred Statistics Publishing: Example
  • Automatic SQL Tuning: Overview
  • Plan Tuning Flow and SQL Profile Creation

 Module 12: In-Memory Column Store

  • Goals of In-Memory Column Store
  • Store Versus Column Store: 2D Vision
  • In-Memory Column Unit
  • Dual Format In Memory
  • Deploying IM Column Store
  • Objects Candidates for IM Column Store
  • Defining IM Column Store Priority
  • Default In-Memory Setting

 Module 13: Introduction to Oracle Data Guard

  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Role Transitions: Switchover and Failover
  • Choosing an Interface for Administering a Data Guard Configuration
  • Primary Database Processes
  • Standby Database Processes
  • Physical Standby Database: Redo Apply Architecture
  • Automatic Gap Detection and Resolution

 Module 14: Using Oracle Active Data Guard

  • Using Real-Time Query
  • Disabling Real-Time Query
  • Checking the Standby’s Open Mode
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Allowed Staleness of Standby Query Data
  • Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger
  • Forcing Redo Apply Synchronization
  • Creating an AFTER LOGON Trigger for Synchronization

 Module 15: Creating a Logical Standby Database

  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • Preparing to Create a Logical Standby Database
  • Unsupported Data Types
  • Checking for Tables with Unsupported Data Types
  • Unsupported PL/SQL-Supplied Packages
  • Adding a Disabled Primary Key RELY Constraint
  • Creating a Logical Standby Database by Using SQL Commands

 Module 16: Enabling Fast-Start Failover

  • When Does Fast-Start Failover Occur?
  • Installing the Observer Software
  • Fast-Start Failover Prerequisites
  • Configuring Fast-Start Failover
  • Step 1: Specify the Target Standby Database
  • Setting the Lag-Time Limit
  • Configuring the Primary Database to Shut Down Automatically
  • Configuring Automatic Reinstatement of the Primary Database

 Module 17: Introduction to Clusterware

  • Clusterware Architecture and Cluster Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Fencing
  • Cluster Time Synchronization
  • Oracle Clusterware Networking
  • Grid Naming Service (GNS)
  • Grid Naming Service Configuration Options
  • Single-Client Access Name

 Module 18: ASM Overview

  • What Is Oracle ASM?
  • ASM Features and Benefits
  • ASM Instance Designs: Clustered ASM for Clustered Databases
  • ASM Components: Software
  • ASM Components: ASM Instance Primary Processes
  • ASM Components: Configuration Files
  • ASM Disk Group: Failure Groups
  • ASM Files: Extents and Striping

 Module 19: Flex Clusters

  • Flex Clusters: Overview
  • Flex Cluster Scalability
  • Leaf Node Characteristics
  • Cluster Mode: Overview
  • Configuring the Cluster Mode
  • Configuring Miss Count for Leaf Nodes
  • Configuring a Flex Cluster with OUI: Configuring GNS
  • Configuring a Flex Cluster with OUI: Selecting the Node Type

 Module 20: Flex ASM

  • Flex ASM: Overview
  • ASM Instance Changes
  • Configuring Flex ASM on a Standard Cluster
  • Configuring Flex ASM on a Flex Cluster
  • Stopping, Starting, and Relocating Flex ASM Instances
  • Setting the Cardinality for Flex ASM Instances
  • Monitoring Flex ASM Connections
  • Relocating an ASM Client

 Module 21: RAC Databases Overview and Architecture

  • Typical Oracle RAC Architecture
  • Oracle RAC One Node
  • Cluster-Aware Storage Solutions
  • Oracle RAC and Network Connectivity
  • Clusters and Scalability
  • Levels of Scalability
  • Speedup/Scaleup and Workloads
  • Necessity of Global Resources

 Module 22: Upgrading and Patching Oracle RAC

  • Patch and Patch Set: Overview
  • Configuring the Software Library
  • Reduced Down-Time Patching for Cluster Environments
  • Out-of-Place Database Upgrades
  • OPatch: Overview
  • Before Patching with OPatch
  • OPatch Automation: Examples
  • OPatch Log and Trace Files

Oracle database 12C : OCM Exam preparation Workshop Ed 1 Course Prerequisites:

1. Previous knowledge about SQL and PL/SQL
2. Working knowledge of basic database concepts
3. Knowledge of Oracle Database 10g/11g
4. Exposure to Oracle Database Architecture
5. Exposure to Oracle Grid Infrastructure and ASM
6. Basic knowledge of Operating System used for Oracle Database Administration (Windows, Linux, etc.)
7. Basic knowledge of Oracle Database Security
8. Hands-on experience with Oracle Database administration tasks
9. Basic understand of Fault Tolerance and Backup & Recovery

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.