About

Martin Klier

usn-it.de

DOAG noon2noon RAC & Dataguard – Quick Report

There’s always something to learn – for example about Oracle RAC (Real Application Clusters) and Dataguard. And the old-school frontal teaching concept is boring, and more important, ineffective after a few hours of passive listening. So the German Oracle Users Group DOAG organized a “noon2noon” event: “Oracle RAC and Dataguard” this week in Würzburg (January 2 1st-22nd 2016). It was the […]

read more

Oracle 11g and 12c Cardinality Feedback Leads to Hundreds of Child Cursors

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 […]

read more

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) […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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 […]

read more