OCM 12c Preparation - Configure the Resource Manager

So Resource Manager for 12c is also pretty the same as Resource Manager for 11g for a database plus the CDB Resource Plans, where you can control how many "shares" and the limitations for each PDB will have in a multi-container environment.

In 12c now you can also set the resource plan directive PARALLEL_STMT_CRITICAL to BYPASS_QUEUE for a high-priority consumer group so that parallel statements from the consumer group bypass the parallel statement queue.

So the most important here is you to know how to create all the Resource Manager objects (Plan, Consumer Groups, Directives, etc) using both SQL*Plus and Cloud Control (preferable because it's faster).

In the official documentation available during the exam, on section 27 and 44 specified below, there are good examples that you may copy, adapt and paste to save several minuted during the exam.

Path to Documentation:

Administrator’s Guide -> 27 Managing Resources with Oracle Database Resource Manager
Administrator’s Guide -> 44 Using Oracle Resource Manager for PDBs with SQL*Plus
Administrator’s Guide -> 45 Using Oracle Resource Manager for PDBs with Cloud Control


Click here to go back to the Main OCM 12c Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.