So here we are!
OCM is a goal for many Oracle DBAs but when we start wondering about the path to get there we see how difficult it is and this may do many people give up. However, with this post explaining each topic covered in the exam using my own self-study I hope to help many people to see that the secret of this exam it is nothing more than study study study … so, are you going to join me in this journey?
1. General Database and Network Administration
- Creating and managing pluggable databases
- Administering users, roles, and privileges
- Configuring the network environment to allow connections to multiple databases
- Administering database configuration files
- Configuring shared server
- Managing network file directories
2. Manage Database Availability
- Installing the EM Cloud Control agent
- Configuring recovery catalog
- Configuring RMAN
- Performing a full database backup
- Configuring and monitoring Flashback Database
3. Data Warehouse Management
- Managing database links
- Managing a fast refreshable materialized view
- Creating a plug-in tablespace by using the transportable tablespace feature
- Optimizing star queries
- Configuring parallel execution
- Applying a Patch
- Configuring Automatic Data Optimization, In-Row Archiving, and Temporal Validity
- Managing external tables
4. Data Management
- Managing additional buffer cache
- Optimizing space usage for the LOB data
- Managing an encrypted tablespace
- Managing schema data
- Managing partitioned tables
- Setting up Fine-Grained Auditing
- Configuring the database to retrieve all previous versions of the table rows
5. Performance Management
- Configuring the Resource Manager
- Tuning SQL statements
- Using real application testing
- Managing SQL Plan Baselines
- Capturing performance statistics
- Tuning an instance – Configure and manage result cache, Control CPU use for Oracle Instances
- Managing extended statistics
- Creating and managing partitioned indexes
6. Data Guard
- Administering a Data Guard environment
- Creating a physical standby database
- Configuring a standby database for testing
- Configuring a standby database to apply redo
- Configuring a standby database to use for reporting
- Configuring fast-start failover
- Managing extended statistics
- Managing DDL in a Data Guard environment
7. Grid Infrastructure
- Installing Oracle Grid Infrastructure
- Creating ASM Disk Groups
- Creating and managing ASM instances
- Configuring ASM Cloud File System (ACFS)
- Administering Oracle Clusterware
- Managing Flex Clusters and Flex ASM
- Managing Flex Clusters and Flex ASM
8. Real Application Cluster Database
- Installing Oracle Database software
- Creating a Real Application Clusters (RAC) database
- Configuring Database Services
- Administering Oracle RAC databases on one or more cluster nodes
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)