About

Martin Klier

usn-it.de

Featured by Oracle Magazine

The Oracle Magazine featured me in its January / February 2016 issue. I really feel honoured and would like to say thank you for the opportunity! For details, please see the Performing Databases Blog post about the publication. […]

read more

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