My last post was about generating AWR reports from SQL – not a very complicated case. “But” – little word, big meaning. And suddenly we get a strange error message. In my example, I was especially interested in a Real Application Cluster’s “global” report. The subprogram call for that purpose is dbms_workload_repository.awr_global_report_text(), accepting the DBID, begin […]
Category: Oracle
What’s the difference between Larry Ellison and god?
How to create an Oracle AWR report with SQL and PL/SQL
AWR is a great tool (but needs diagnostics pack). It can create very useful reports for performace analysis over a given period. Most people will pull the AWR Report from the OS level, with ‘@?/rdbms/admin/awrrpt.sql” (or one of the other scripts there). But sometime it’s not possible to access a database server’s OS level, or […]
Oracle 12c RMAN delete obsolete behaves interactively in DBMS_SCHEDULER job type BACKUP_SCRIPT
Situation In Oracle Database 12c, we have the long-missed feature of DBMS_SCHEDULER job type “BACKUP_SCRIPT”, that allows us to create backup jobs without creating them as an OS file, and without need for a wrapper script that’s called by a job type EXECUTABLE (as we usually did that in the last years). Sometimes we also […]
DOAG Database Conference 2015 begins #DOAGDB15
It’s time! June 16th, the DOAG Database Conference takes place in Düsseldorf, Van Der Valk Airport Hotel. Twenty-two specialized talks about Oracle Database, Replication, Tools and Security promise a great techie-day. See the schedule of lectures here. I’m looking forward to seeing you there, having great corner talks about Oracle, life and lemons, tweeting with […]
DOAG BI Conference: Oracle Core (for Beginners): In-Memory Column Store
On Thursday, April 23rd I’m speaking at DOAG BI 2015, the leading Oracle Business Intelligence Conference in Germany. (#DOAGBI15) My contribution is: “Oracle Core für Einsteiger: In-Memory Columns Store”. The lecture will show, how the Oracle Database In-Memory option works “under the hood”, and how it is used to the best effect. Please find the presentation […]
Martin Klier Oracle ACE
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, […]
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 […]