Enterprise Manager Cloud Control 12c provides us with means to take total control of our Security, Monitoring and Incident Management models. Using Administration and Dynamic Groups, Roles and Administrator controlled ‘Solution Groups’ we are able to route Incidents based on our organization structure.
Therefor we are more and more relying on Target Properties like: Lifecycle Phase, Line Of Business, Department etc. When monitoring thousands of Targets, management of these Properties is a huge challenge.
I am working towards upgrading databases from 126.96.36.199 to 188.8.131.52. This should go smoothly, right? Well after I upgraded a development database, I got a call about a slow performing query. In all of the 184.108.40.206 databases, the query runs in about 50 seconds. In the 220.127.116.11 databases, the query runs in 4 minutes. The execution plans are different even though the table/index stats are identical. So this is a version-related problem. One of the things I did was to check the parameters between the different versions.