Category: OCM 12c Preparation

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

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

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

For OCM11g, this topic was written as Perform various recovery operations using Flashback technology but it's pretty the same thing. Here, you must be able and focus in all possible ways to get back the rows of a table in all possible scenarios. We usually think on flashback technology but in 12c we also have the …

Continue reading

This topic is very similar with the one we had for OCM 11g but here we need to consider not only all the partitioned methods that we had in 11g but also the new features regarding partitioned table in 12c. So practice here: Basic Partitioning Strategies: RANGE, LIST and HASH. Advanced Partitioning Strategies: REFERENCE, INTERVAL, SYSTEM …

Continue reading