客服微信
学习人数：284
课程类型：认证培训
课时长度：25天/150课时
Oracle Certified Master (OCM)是Oracle认证大师，是Oracle认证的最高级别，也是对数据库从业人员的技术、知识和操作技能的最高级别的认可，IT界顶级认证之一。Oracle OCM是解决最困难的技术难题和最复杂的系统故障的最佳Oracle专家人选，也是IT行业衡量IT专家和经理人的最高专业程度及经验的基准。OCM将成为企业内的资深专家和顾问。
Oracle 数据库 19c OCM考试基于 Oracle Database 19c 版本（模块 1-3：19.3.0.0.0 - 64 位，模块 4：19.15.0.0.0 - 64 位），包括使用 Oracle 实际应用集群 （Oracle RAC）。操作系统是Oracle Linux Server Release 7.9（64位）。
考试环境介绍
1、Oracle Linux Server 7.9 版
2、辅助工具：Mozilla 浏览器，vi 编辑器，（网关机也可以使用 gedit 作为编辑器）
3、shell环境：bash
4、使用命令行、GUI 和可用工具
5、Oracle 数据库 19c 企业版（模块 1-3：19.3.0.0.0 - 64 位，模块 4：19.15.0.0.0 - 64 位）
6、Oracle SQL Developer 19.2.1
7、Oracle 网格基础设施 19c 版本 15 （19.15.0） *仅适用于某些任务
8、企业管理器云控制 13c 版本 5 （13.5.0） *仅适用于某些任务
19c OCM考试类别
19c OCM考试类别
Oracle数据库19c：Oracle认证大师（OCM）直考（2天考试，4个模块，每个模块3小时）
Oracle数据库19c：Oracle认证大师（OCM）升级考试（1天考试，2个模块，每个模块3小时）
在注册参加19c OCM考试之前
如果之前有OCM证书，选择19c OCM升级考
在注册19c OCM升级考试之前，必须完成之前的OCM认证之一：
知识点：多租户
第一部分：CDB介绍
01.CDB Basics
02.CDB and Regular PDBs
03.Application PDBs and Application Installation
第二部分：PDB介绍
01.PDB Creation
02.CDB and PDB Management
03.Storage
第三部分：多租户管理
01.Data Movement
02.Upgrade Methods
03.Miscellaneous
04.Processes, Views, Parameters, Packages, and Privileges
05.Consolidated Database Replay Procedures
第四部分：多租户安全
01.Security
02.Backup and Duplicate
03.Recovery and Flashback
03.Performance
04.Resources Allocation
知识点：性能优化第一部分：性能诊断工具
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
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 Issue
第二部分：SQL优化基础
01.Overview of SQL Statement Processing
02.Maintaining Indexes
03.Maintaining Tables
04.Introduction to Query Optimizer
05.Understanding Execution Plans
06.Viewing Execution Plans by Using SQL Trace and TKPROF
07.Managing Optimizer Statistics
08.Using Automatic SQL Tuning
09.Using the SQL Plan Management Feature
第三部分：SQL自动调优
01.Overview of the SQL Advisors
02.Using the SQL Tuning Advisor
03.Using the SQL Access Advisor
04.Overview of Real Application Testing Components
05.Using SQL Performance Analyzer to Determine the Impact of Changes
06.Using Database Replay to Test System Performance
第四部分：内存调优
01.Implementing Real-Time Database Operation Monitoring
02.Using Services to Monitor Applications
03.Overview of Memory Structures
04.Managing Shared Pool Performance
05.Managing Buffer Cache Performance
06.Managing PGA and Temporary Space Performance
第五部分：In-Memory技术
01.Configuring the Large Pool
02.Using Automatic Shared Memory Management
03.Introduction to In-Memory Column Store
04.Configuring the In-Memory Column Store Feature
05.Using the In-Memory Column Store Feature to Improve SQL Performance
06.Using In-Memory Column Store with Oracle Database Features知识点：高可用第一部分：Clusterware
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
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
第二部分：ASM
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
第三部分：RAC
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
第四部分：DG
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考前辅导Module1
01.General database
02.network administration
Module2
01.Backup/Recovery
02.Data Management
Module3
01.Perormance management
02.Configuring Data Guard
Module4
01.Configuring Real Application Clusters
Module5
01.exercise
02.answer questions
郭一军
云贝教育创始人 腾讯云TVP PostgreSQL ACE
