Sometimes, advanced features can bring advanced problems. Seeing a project with hundreds of child cursors with a different execution plan each, is never a pleasure, but there has to be a reason. In fact, we are talking about the “USE_FEEDBACK_STATS” reason in v$sql_shared_cursor. Its meaning is: “A hard parse is forced so that the optimizer can reoptimize […]
Year: 2015
What is a “RAC Battle”?
RAC Battle [ræk ˈbæt̬l̩] What is a “RAC Battle”? It is a format of presenting technology – two experts, battling against each other on pros and cons of Oracle Real Application Cluster. Björn Rost (Oracle ACE Director) and Martin Klier (Oracle ACE) will fight Wednesday November 18th, 2015 11 am Nürnberg CCN (DOAG Konferenz 2015) […]
Oracle Database 11.2 Extended Support Waived
As announced today, Oracle waived the Extended Support for the period of February 2015 until May 2017. See the paper with details here. […]
Oracle 12c in practice – customer report in Cologne #12cjetzt
From Beta to Production – Oracle 12c at TGW In October, I’ll speak at the Oracle #12jetzt (#12cnow) symposium in Köln (Cologne) about the introduction of 12c as standard palttform at our ISV customer TGW Software Services. I had the privilege to continuously working on the 12c product evaluation and introduction from availability of 12c beta2 […]
Oracle dbms_workload_repository awr_global_report_text fails with ORA-06553 PLS-307
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 […]
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 […]
Chemnitzer Linux Tage 2015
Last weekend, I had the chance to attend the Linux Days Chemnitz. It’s an annual meeting of the German Linux family with roundabout 2,500 attendees and a FANTASTIC atmosphere. It was two days of hearing tech talks, enjoying rich nerd content and talkin’ shop. […]