June 2017 archive

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

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