Oracle 12c OCM可能在2023年停考讓我們一起回顧一下該考試

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-