Instrumentation 2.0: "Performance is a Feature"
Lasse Jenssen, Eritec
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.
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".