Oracle Whitepapers / Presentations

 

Title Description Date
Oracle Identity Management (OIM) Tech Day Presentation on using the Oracle LDAP server (OID) for user authentication with 3 cases studies. Originally presented at an Oracle Tech Day in Dallas in 2005. 02/02/05
How NOT to Build an Oracle Application! A schizophrenic paper that covered two distinct topics. The first half of the presentation stuck to the original topic. It’s a top ten list of things not to do when building an Oracle based application. The second half of the paper dealt with creative problem solving techniques relating to Oracle systems. This paper was originally presented at the Hotsos Symposium held in Dallas 2006. 02/28/06
Creative Problem Solving for Oracle Systems Whitepaper version of the “Creative Problem Solving” portion of the original “How NOT to Build an Oracle Application” presentation. 03/06/06
How NOT to Build an Oracle Application - Rev2 An updated version of the 2006 Hotsos Symposium paper that just has the top ten list of worst things to do when developing an Oracle based application. 08/17/07
Oracle Tech Day - Migration to 10g Oracle Tech Day presentation in Dallas on why you should upgrade to 10g. This was a tag team presentation with Randy Johnson. 10/04/07
Tuning Oracle Systems Two part presentation on tuning Oracle Systems. The “Soft Skills” part focuses on how we think about tuning and the approaches we use. This includes a technique for producing a 3 dimensional graph plotting cost/benefit/risk. The “Hard Skills” part focuses on tools and techniques that can be used to solve Oracle performance problems. These include o/s tools, SQL scripts, and trace file analysis. The zip file contains a power point presentation as well as output from some of the scripts discussed. This presentation was originally done for an internal training event at the Dallas Enkitec office. 10/26/07
Oracle Wait Events That Everyone Should Know This was another internal training presentation at Enkitec. A top ten (more or less) list of Oracle Wait Events, what causes them, how long they should take, and ways to reduce the amount of time spent on each event. There is also a brief discussion of how and why Explain Plan lies and what to do to get Oracle to tell the truth. 05/22/08
Oracle 11g Advanced Features This was originally an Oracle Tech Day presentation that was co-presented with Randy Johnson. I later cleaned it up a bit and delivered it at an internal Enkitec training session. It is a discussion of several features that are new in 11g, mostly performance related. Topics include Results Cache, Real-Time SQL Monitoring, a new Plan Stability Model, Virtual Columns, Invisible Indexes and Statistics Enhancements. The zip file contains the presentation and 2 text files with demonstrations of the Results Cache feature and the Real-Time SQL Monitoring feature. 10/23/08

Leave a comment