Jul 21

OCM 11g Preparation – Install Oracle Grid Infrastructure

So, finally here we start the grid control! I won’t teach you here how to install grid control as you can find 266k results in less than 0.5 seconds using Google. There are several ways of doing so and you must be prepared to perform all of them: runInstaller using GUI (preferable). runInstaller using CLI …

Continue reading

Jul 20

OCM 11g Preparation – Implement instance caging

I’ve never heard about this expression “instance caging” until I came across this topic. So, I made a quickly search in the official documentation and it was a single page to explain everything. Fast to learn. “Instance caging is a method that uses an initialization parameter to limit the number of CPUs that an instance can …

Continue reading

Jul 20

OCM 11g Preparation – Use SQL Plan Management feature

SQL Plan Management is a new feature introduced with Oracle DB 11g that enables the system to automatically control SQL plan evolution by maintaining SQL plan baselines. 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 …

Continue reading

Jul 18

OCM 11g Preparation – Configure baseline templates

There are three types of baselines: Fixed, Moving Windows and Templates. In this chapter, we will focus in the third one, where our target is to create baselines for a contiguous time period in the future. There are two types of baseline templates: single and repeating. They are very easy to create through “DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE” procedure. In …

Continue reading

Jul 16

OCM 11g Preparation – Use SQL Performance Analyzer

Performance Analyser is specially good when we are doing an Upgrade in our Oracle Version, so you can check the times of the queries before/after the change. But for OCM, only 11gR2 is required to study. So probably, we will face another type of changement, like: Parameter Change Optimizer Statistics Practice here creating a SQL Tuning …

Continue reading