Oracle Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4)

Oracle has released today the next Release for the Oracle Enterprise Manager Cloud Control 12c 12.1.0.4. You can download it from the Oracle  Technology Network Page here. This release is certified to use 11.2.0.3,11.2.0.4 and 12.1.0.1 Oracle Database as repository database. Don`t forget to checkout the Oracle Blog Post for more details about the new…

That was the AOUG conference day 2013

In recent days, the AOUG User Conference 2013 was held. There are many intresting topics presented and I recommend anyone to see the presentations that can be  downloaded. The picture above shows me during the presentation of the topic „Jailbreak Database Tuning & Monitoring“. Pictures and more information can be found here.

Query zur Laufzeit ändern

Zeitweise hat man das Problem das ein DBA vor einer Abfrage steht, welche ein Problem (Performance, Werte, etc.) verursacht, jedoch in die Applikation nicht eingegriffen werden kann. Auf einer Enterprise Edition gibt es hier einen kleinen Trick den man anwenden kann. Vorbereitung Dem Benutzer werden entsprechende Rechte gegeben. GRANT EXECUTE ON DBMS_ADVANCED_REWRITE TO scott; GRANT…