I feel VERY proud, honoured and grateful, that Oracle awarded me with the Oracle ACE in December 2014. The Oracle ACE program is a community reward, and encourages us to participate, enrich, promote and organise Oracle community events. When speaking about the community, first of all I’d like to highlight my Oracle User Group of Germany, […]
Year: 2015
Speaker at DOAG 2015 Datenbank – “Oracle Core für Einsteiger: InMemory Column Store”
The DOAG 2015 Database conference is on the horizon: June 16, 2015 in Düsseldorf, Germany. I’m proud to announce my participation as a speaker, as I was honoured with in the years before. This year, my part will be a new “Beginners” talk in German: “Oracle Core für Einsteiger: InMemory Column Store” Abstract: ==================== Der Vortrag richtet […]
DOAG Noon2Noon Event Nürnberg / MySQL vs. Oracle – Review
It was time to try something new in our DOAG Database Community. And please, please just not another frontal conference: twenty guys look forward, one looks back, like eight-oars-and-coxswain. I don’t know if DOAG invented it, but it was a success: The Noon2Noon Event. How does it work? It’s like 24 hours of BarCamp, starting with […]
Oracle 12c Multitenant: impdp fails w/ ORA-31625 and ORA-01031 because of Database Vault
Things are different in Oracle Database 12c with multitenancy option. My most recent example: I tried to import a schema (new name “NEWSCHEMA”) with datapump IMPDP and REMAP_SCHEMA into the same pluggable database it has been exported from with EXPDP immediately before (name “OLDSCHEMA”), running as SYSTEM. I’m doing things like that with DBA permissions, since […]
Oracle: Did my SQL get worse over time? (AWR query)
Sometimes, we get statements to look at, and are told “it’s getting worse and worse”. Since DBAs are well advised not to take anything for granted and only to believe what they see with own eyes, here comes a SQL on AWR to see Buffer Gets per Minute, over time. select s.BEGIN_INTERVAL_TIME, round(t.BUFFER_GETS_DELTA/ 0.0001+ (extract […]