.
\nThe OCM exam advice says:
\n Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax.
\nI’ve checked that I can find quickly the documentation related with each topic listed. Here it is
\n
\nAs in the previous posts, I write that before taking the exam, from only the list of topics, and I may be completely wrong. You are not supposed to go to documentation for every topic during the exam or you will probably be short on time. There are a lot of things we can do directly because it’s things we do in our daily job life. For the exam, remember to use the right tools and that may be different from what you use in real life. For example, in your job you may do everything from command line because you have the syntax on your procedure documents, or from a quick Google search. At the exam, you may favor the tools that have enough online help, checkboxes or autocompletion.<\/p>\n
Anyway, if there are some points where you have a doubt and still have time to open documentation, it’s good to know where to find syntax or examples to copy\/paste.<\/p>\n
Database Administration Security Database Administration High Availability Database Administration Data Warehousing and Business Intelligence Database Administration Data Warehousing and Business Intelligence Application Development Database Administration Performance Database Administration Performance High Availability High Availability High Availability Install Oracle Grid Infrastructure I’ll not detail all points for the GI \/ RAC for 3 reasons<\/p>\n
\nAdministrator’s Guide
\nPart VI Managing a Multitenant Environment
\n38 Creating and Removing PDBs with SQL*Plus<\/a>
\nThere are many alternatives depending on the tools: sqlplus, sqldev, dbca, OEM, etc.<\/p>\nCreate and manage users, roles, and privileges<\/h3>\n
\nSecurity Guide
\nPart I Managing User Authentication and Authorization
\n2 Managing Security for Oracle Database Users
\nCreation of a Common User or a Local User<\/a>
\n4 Configuring Privilege and Role Authorization
\nManaging Commonly and Locally Granted Privileges<\/a>
\nHere the main 12c thing is about common or local roles \/ privileges \/ grants, etc.<\/p>\nConfigure the network environment to allow connections to multiple databases<\/h3>\n
\nNetwork Management
\nNet Services Administrator’s Guide
\n8 Configuring Naming Methods
\nConfiguring the Local Naming Method<\/a>
\nRather than checking syntax from doc, we can use netca, netmgr, and samples files<\/p>\nProtect the database from loss of data due to any kind of failure<\/h3>\n
\nBackup and Recovery
\nDatabase Backup and Recovery User’s Guide
\n9 Backing Up the Database
\nBacking Up Database Files with RMAN<\/a>
\nBackup the database, the spfile, the controlfile, etc… <\/p>\nCreate and manage database configuration files<\/h3>\n
\nSQL Language Reference
\n11 SQL Statements: ALTER LIBRARY to ALTER SYSTEM
\nALTER SYSTEM<\/a>
\nI suppose it’s about instance parameters here, that can be set at CDB or PDB levels<\/p>\nData and Performance Management<\/h2>\n
Modify materialized views<\/h3>\n
\nData Warehousing Guide
\nPart II Optimizing Data Warehouses
\n5 Basic Materialized Views
\nRefresh Options<\/a>
\n7 Refreshing Materialized Views
\nFast Refresh<\/a>
\n8 Synchronous Refresh
\nThere are a lot of things we can do on Materialized views… Fast Refresh and Query Rewrite are the main features that may need us to modify them<\/p>\nCreate a plugged-in tablespace by using the transportable tablespace feature<\/h3>\n
\nDatabase Administrator’s Guide
\n15 Transporting Data
\nTransporting Tablespaces Between Databases<\/a>
\nIn 12c we can transport a whole database or pluggable database with impdp FULL=Y. It’s good to know that RMAN can convert between endianness.<\/p>\nCreate partitioned tables<\/h3>\n
\nVLDB and Partitioning Guide
\n3 Partitioning for Availability, Manageability, and Performance
\nThe 12c new feature is: Creating Interval-Reference Partitioned Tables<\/a><\/p>\nConfigure the database to retrieve all previous versions of the table rows<\/h3>\n
\nDatabase Development Guide
\nPart IV Advanced Topics for Application Developers
\n16 Using Oracle Flashback Technology
\nUsing Flashback Data Archive<\/a>
\nThere are other ways to find previous versions (flashback query, restore table, etc)<\/p>\nConfigure the Resource Manager<\/h3>\n
\nDatabase Administrator’s Guide
\n27 Managing Resources with Oracle Database Resource Manager
\nCreating a Simple Resource Plan<\/a>
\nIn 12c Resource Manager has more possibilites, at CDB and PDB levels<\/p>\nTune SQL statements<\/h3>\n
\nSQL Tuning Guide
\nPart VIII Automatic SQL Tuning
\n20 Analyzing SQL with SQL Tuning Advisor
\nRunning SQL Tuning Advisor On Demand<\/a>
\nThis topic is a large one…<\/p>\nPerform real application testing<\/h3>\n
\nDatabase Testing Guide
\nPart II Database Replay<\/a>
\nRAT is quite straightforward in OEM.<\/p>\nCreate SQL Plan baselines<\/h3>\n
\nSQL Tuning Guide
\n23 Managing SQL Plan Baselines
\nLoading SQL Plan Baselines<\/a>
\nThere are several ways to create SQL Plan baselines: capture, load, etc.<\/p>\nData Guard<\/h2>\n
Create a physical standby database<\/h3>\n
\nData Guard Concepts and Administration
\n3 Creating a Physical Standby Database<\/a>
\nE Creating a Standby Database with Recovery Manager
\nUsing the DUPLICATE Command to Create a Standby Database<\/a>
\nOEM can be a nice alternative here even if I never use it to create physical standby in production (prefer command line – easier to put in documentation that lot of screenshots)<\/p>\nMake the standby database available for testing, Restore the standby database to its normal function<\/h3>\n
\nData Guard Concepts and Administration
\n10 Managing Physical and Snapshot Standby Databases
\n10.7 Managing a Snapshot Standby Database<\/a><\/p>\nConfigure fast start failover<\/h3>\n
\nData Guard Broker
\n4.8 Managing Fast-Start Failover
\n5 Switchover and Failover Operations
\n5.5 Fast-Start Failover
\n5.5.2 Enabling Fast-Start Failover<\/a><\/p>\nGrid Infrastructure and Real Application Clusters<\/h2>\n
\nConfigure Oracle Flex ASM
\nCreate ASM disk groups
\nCreate and manage an ASM instance
\nCreate ACFS
\nStart, stop, configure, and administer Oracle Grid Infrastructure
\nInstall the Oracle Database 12c software
\nCreate RAC databases
\nConfigure services<\/p>\n