Jul 03

OCM 12c Preparation - Install Oracle Grid Infrastructure

Grid control along with data guard are within my favorite topics. So here you must know how to install grid infrastructure in ways you are not used to (runInstaller interface). There are several ways of installing and you must be prepared to perform all of them: runInstaller using GUI (preferable and fastest). runInstaller using CLI …

Continue reading

Jun 28

OCM 12c Preparation - Create SQL Plan baselines

SQL Plan Baselines is a feature introduced with Oracle DB 11g that enables the system to automatically control SQL plan evolution. With this enabled, a newly generated SQL plan can integrate a SQL plan baseline only if it has been proven that doing so will not result in performance regression. During execution of a SQL statement, only a …

Continue reading

Jun 24

OCM 12c Preparation - Perform real application testing

This is another topic that you should avoid at all costs using any approach different from Oracle Enterprise Manager. It will save you a lot of time! Real Application Testing = Database Replay + SQL Performance Analyzer Performance Analyser is specially good when we are doing an Upgrade in our Oracle Version, so you can check …

Continue reading

Jun 24

OCM 12c Preparation - Tune SQL statements

Well, this is the most broader topic. With no specific thing being said, Tune SQL simply means "make it runs faster!". So, here there is no much to say. Practice counts much more than theory knowledge for this one. What I would recommend here is the same I said for 11g exam: consider here the …

Continue reading

Jun 22

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 …

Continue reading