Oracle 12c OCM在2023年1月底预计会停考，让我们一起再来回顾一下该考试的大纲，12c OCM知识体系完成，是从生产实战角度去知识点和技能进行全面的考核。

一、考试概况

Oracle Database 12c Certified Master (OCM) Exam Information

考试时间：2天

考试地点：北京或上海OCM考场

通过成绩：59.95%

考试共有8个实战技术场景,通过上机实战操作完成。

每个场景最低通过成绩：注意每个场景达到最低成绩同时总的平均成绩不能低于59.95%

Skillset-1 : Create Database and Network Configurations -: 60.29%·

Skillset-2: Managing Database Availability -: 46.93%·  

Skillset-3: Data Warehouse Management -: 34.14%·  

Skillset-4: Data Management -: 33.92%·        

Skillset-5: Performance Management -: 39.13%·      

Skillset-6: Data Guard -: 43.39%·      

Skillset-7: Grid Infrastructure -: 53.84%·       

Skillset-8: Real Application Cluster Database -: 37.83%

考试基础环境：

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 12.1.0.2.0 64 bit·         

Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)·         

Oracle Enterprise Manager Cloud Control 12c Rel 4.

考试参考资料：Oracle数据库离线官方文档

二、考试大纲

1-General Database and Network Administration

Create and manage pluggable databases·

Administer users, roles, and privileges·

Configure the network environment to allow connections to multiple databases·

Administer database configuration files·

Configure shared server·

Manage network file directories.

2-Data Warehouse Management

Manage database links·    

Manage a fast refreshable materialized view·    

Create a plug-in tablespace by using the transportable tablespace feature·    

Optimize star queries·     

Configure parallel execution·    

Apply a Patch·   

Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity·    

Manage external tables.

3-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.

4-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.

5-Manage Database Availability 

Install the EM Cloud Control agent

Configure recovery catalog·

Configure RMAN·

Perform a full database backup·

Configure and monitor Flashback Database.

6-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.

7-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

8-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

我的证书

-the end-