About

Martin Klier

usn-it.de

Very cool interview with Maria Colgan

Community work can be so much fun. When working for the German Oracle User Group, DOAG, one of my favourite jobs is interviewing interesting people for doag.tv. In fall 2019, we recorded a fun interview with Maria Colgan, Master Product Manager for the Oracle Database. I had the chance to prepare the story: Based on […]

read more

Oracle PGA Analysis Query

Sometimes, something in an Oracle Database starts eating PGA, and there is need to find out which process, and where the memory is left, and what or who is responsible for allocating / using / holding it. For a recent issue, I wrote the SQL below. It gives back one line for each Category (SQL, […]

read more

Oracle ACE Director

Uh, there has been no blog entry for some time, had a busy time. So now I have a good reason to blog after returning from Collaborate18 in Las Vegas, where I had the chance to present two talks about SQL Tuning and Oracle Performance on VMware. The Oracle ACE Program usually hosts a dinner […]

read more

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

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