19c OCM考试介绍
考试分为直考和升级考两种形式
考试形式:OCM考试全部为上机实操考试,没有笔试部分。
考试地点:北京/上海指定的Oracle线下考场进行。
① 北京考试地点:北京市海淀区中关村软件园24号楼甲骨文大厦T2,3楼3006房间)
② 上海考试地点:上海市黄浦区天津路155号名人商业大厦12层甲骨文公司,12012房间)
考试时间:
-
直考:为期两天,共4个模块,每个模块3小时,需全部合格。
-
升级考:为期一天,共2个模块,每个模块3小时,适用于已持有其他版本OCM证书的考生。
考试内容:考试内容涵盖Oracle Database 19c的高级管理、维护、优化和故障排除等方面,包括但不限于数据库和网络管理、备份与恢复、性能调优、Data Guard管理、Real Application Clusters (RAC) 配置等。
19c OCM考试通过分数
直考考试为期2天,一共四个场景,每个场景考试时间为3小时。
升级考考试为期1天,一共2个场景,每个场景考试时间为3小时。
OCM证书样本
28天实战技术培训+OCM考试辅导
课程 | 课程 | 时间/ 上课方式 |
01.Oracle Database 19c: Managing Multitenant Architecture | 01.CDB Basics 02.CDB and Regular PDBs 03.Application PDBs and Application Installation | 多租户 (4天/录播) |
04.PDB Creation 05.CDB and PDB Management 06.Storage | ||
07.Security 08.Backup and Duplicate 09.Recovery and Flashback 10.Performance 11.Resources Allocation | ||
12.Data Movement 13.Upgrade Methods 14.Miscellaneous 15.Processes, Views, Parameters, Packages, and Privileges 16.Consolidated Database Replay Procedures | ||
02.Oracle Database 19c: Performance Management and Tuning | 01.Overview 02.Defining the Scope of Performance Issues 03.Using the Time Model to Diagnose Performance Issues 04.Using Statistics and Wait Events to Diagnose Performance Issues 05.Using Log and Trace Files to Monitor Performance 06.Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance | DB Performance & SQL Tuning (6天/直播) |
07.Using Statspack to View Performance Data 08.Using Automatic Workload Repository 09.Using Metrics and Alerts 10.Using Baselines 11.Managing Automated Maintenance Tasks 12.Using ADDM to Analyze Performance 13.Using Active Session History Data for First Fault System Analysis 14.Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues | ||
15.Overview of SQL Statement Processing 16.Maintaining Indexes 17.Maintaining Tables 18.Introduction to Query Optimizer 19.Understanding Execution Plans 20.Viewing Execution Plans by Using SQL Trace and TKPROF 21.Managing Optimizer Statistics 22.Using Automatic SQL Tuning 23.Using the SQL Plan Management Feature | ||
24.Overview of the SQL Advisors 25.Using the SQL Tuning Advisor 26.Using the SQL Access Advisor 27.Overview of Real Application Testing Components 28.Using SQL Performance Analyzer to Determine the Impact of Changes 29.Using Database Replay to Test System Performance | ||
30.Implementing Real-Time Database Operation Monitoring 31.Using Services to Monitor Applications 32.Overview of Memory Structures 33.Managing Shared Pool Performance 34.Managing Buffer Cache Performance 35.Managing PGA and Temporary Space Performance | ||
36.Configuring the Large Pool 37.Using Automatic Shared Memory Management 38.Introduction to In-Memory Column Store 39.Configuring the In-Memory Column Store Feature 40.Using the In-Memory Column Store Feature to Improve SQL Performance 41.Using In-Memory Column Store with Oracle Database Features | ||
03.Oracle Database 19c: Clusterware Administration Workshop | 01.Introduction to Clusterware 02.Accessing an Oracle Database 03.Cluster Configuration Options 04.Grid Infrastructure Preinstallation Tasks 05.Grid Infrastructure Installation 06.Managing Cluster Nodes | 高可用 (10天/直播) |
07.Traditional Clusterware Management 08.Policy-Based Cluster and Capacity Management 09.Upgrading and Patching Grid Infrastructure 10.Monitoring and Troubleshooting Oracle Clusterware 11.Making Applications Highly Available with Oracle Clusterware | ||
04.Oracle Database 19c: ASM Administration Workshop | 01.ASM Overview 02.Administering ASM Instances 03.Flex ASM 04.Administering ASM Disk Groups Part I 05.Administering ASM Disk Groups Part II 06.Flex ASM Disk Groups | |
07.Administering ASM Files, Directories, and Templates 08.Administering Oracle ACFS 09.ACFSADVM Enhancements 10.Oracle ASM Advanced Topics 11.Point-In-Time Database Clones | ||
05.Oracle Database 19c: RAC Administration Workshop | 01.Grid Infrastructure:Overview 02.RAC Databases Overview and Architecture 03.Installing with Configuring Oracle RAC 04.Oracle RAC Administration 05.Upgrading and Patching Oracle RAC | |
06.Managing Backup and Recovery for RAC 07.Global Resource Management Concepts. 08.RAC Database Monitoring and Tuning. 09.Managing High Availability of Services 10.High Availability for Connections and Applications | ||
11.Oracle RAC One Node 12.Oracle Database In-Memory in RAC 13.Multitenant Architecture and RAC 14.Quality of Service Management | ||
06.Oracle Database 19c: Data Guard Administration Workshop | 01.Introduction to Oracle Data Guard 02.Oracle Net Services in a Data Guard Environment 03.Creating a Physical Standby Database by Using SQL and RMAN Commands 04.Managing Physical Standby Files After Structural Changes on the Primary Database 05.Using Oracle Active Data Guard Supported Workloads in Read-Only Standby 06.Using Oracle Active Data Guard Far Sync and Real-Time Cascading | |
07.Creating and Managing a Snapshot Standby Database 08.Creating a Logical Standby Database 09.Oracle Data Guard Broker Overview 10.Creating a Data Guard Broker Configuration 11.Monitoring a Data Guard Broker Configuration 12.Configuring Data Protection Modes | ||
13.Optimizing and Tuning a Data Guard Configuration 14.Performing Role Transitions 15.Using Flashback Database in a Data Guard Configuration 16.Enabling Fast-Start Failover 17.Backup and Recovery Considerations in an Oracle Data Guard Configuration 18.Enhanced Client Connectivity in a Data Guard Environment 19.Patching and Upgrading Databases in a Data Guard Configuration | ||
07.Oracle Database 19c:Examination guidance | Module1:General database |
OCM认证 考试辅导 (7天/录播+ 1天/直播) |
Module1:.network administration | ||
Module2: Backup/Recovery | ||
Module2: Data Management | ||
Module3: Perormance management | ||
Module3: Configuring Data Guard | ||
Module4: 01.Configuring Real Application Clusters | ||
01.exercise 02.answer questions |