OCM 12c Preparation

Oracle OCM 12c Certification Study project.

Oracle Database 12c Certified Master Exam | 12cOCM

Exam Environment
  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release  64 bit
  • Oracle Grid Infrastructure 12Release 1 (
  • Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
  • Exam participants work through eight skillsets that are based on the exam objectives.
  • Tasks can be performed using CLI or GUI environment and tools when available

Minimum Skill-set wise Passing Scores:

Skillset1: Create Database and Network Configurations : 60.29%

Skillset2: Managing Database Availability : 46.93%

Skillset3: Data Warehouse Management : 34.14%

Skillset4: Data Management : 33.92%

Skillset5: Performance Management : 39.13%

Skillset6: Data Guard : 43.39%

Skillset7: Grid Infrastructure : 53.84%

Skillset8: Real Application Cluster Database : 37.83%


General Database and Network Administration

Manage Database Availability

Data Management

  • Manage additional buffer cache
  • Optimize space usage for the LOB data
  • Manage an encrypted tablespace
  • Manage schema data
  • Manage partitioned tables
  • Set up Fine-Grained Auditing
  • Configure the database to retrieve all previous versions of the table rows

Data Warehouse Management

Performance Management

  • Configure the Resource Manager
  • Tune SQL statements
  • Use real application testing
  • Manage SQL Plan baselines
  • Capture performance statistics
  • Tune an instance
  • Configure and manage result cache
  • Manage extended statistics
  • Create and manage partitioned indexes
  • Control CPU use for Oracle Instances
  • Configure and manage “In Memory” features

Data Guard

  • Administer a Data Guard environment
  • Create a physical standby database
  • Configure a standby database for testing
  • Configure a standby database to apply redo
  • Configure a standby database to use for reporting
  • Configure fast start failover
  • Manage DDL in a Data Guard environment

Grid Infrastructure

  • Install Oracle Grid Infrastructure
  • Create ASM Disk Groups
  • Create and manage ASM instances
  • Configure ASM Cloud File System (ACFS)
  • Administer Oracle Clusterware
  • Manage Flex Clusters and Flex ASM

Real Application Cluster Database

  • Install Oracle Database software
  • Create a Real Application Clusters (RAC) database
  • Configure Database Services
  • Administer Oracle RAC databases on one or more cluster nodes

3 thoughts on “OCM 12c Preparation

  1. Pingback: General Database and Network Administration  | ORACLE -LEARN

  2. Pingback: OCM 12c Preparation for General Database and Network Administration | ORACLE -LEARN

  3. Pingback: Manage Database Availability | ORACLE -LEARN

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 )

Google photo

You are commenting using your Google 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.