This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Lasse Jenssen

Instrumentation 2.0: "Performance is a Feature"


Lasse Jenssen, Eritec


 

Abstract

You might have been instrumenting you code using the Oracle End-to-end metrics such as Module, Action and ClientId. If not, it's about time. From database version 12c Oracle gives you even more choices, and introduces some new tags, for instance ECID and DBOP. In this presentation we'll explore how we can use these tags together with the MONITOR hint, the dbms_monitor package and the v$sql_monitor view. Performance is not something that just show up, or something you do after deployment of your application. Performance must be built into your application, and the instrumentation becomes the key feature.  

Speaker Biography

An Oracle geek which worked as an Oracle DBA for several years, spending a lot of his time firefighting performance issues. Getting tired of the firefighting, he moved from operation towards development, spending his last 10 years working as an database resource in Java projects. But getting involved in a Java project is not the same as getting listened to. One of his very important experiences are: "As a DBA you might have the answer, but as long as the developer don't get your message, it won't really help".