| 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 |
| Oracle Performance for Developers and the DBAs Who Love Them |
This is a presentation I did at the Hotsos Symposium in 2009. The title kind of says it all. I have delivered this talk several times to various audiences. |
03/11/09 |
| Upgrading to 11gR2 – How to Avoid Performance Regressions |
This is a presentation I did on upgrading to 11g at an Oracle Special Event at Cowboys Stadium. Topics include how to minimize performance regressions during the upgrade due to plan changes.I presented it a second time at a Dallas Oracle Users Group meeting in Nov. of 2009. |
10/28/09 |
| Controlling Execution Plans |
This is a presentation I did at the Hotsos Symposium in 2010 on techniques for controlling execution plans. Covers reasons for needed to exert controlling over execution plans including reasons for instability. A key topic in this presentation is SQL Profiles. There is an associated zip file with the scripts discussed in the presentation. |
03/08/10 |
| Controlling Execution Plans Zip file |
Contains scripts discussed in the associated presentation. |
03/08/10 |
| My Favorite Scripts – 2010 |
This is a presentation I did at the Hotsos Symposium in 2010 which basically just covered a bunch of the scripts that use when diagnosing Oracle performance issues. There is an associated zip file with the scripts. |
03/09/10 |
| My Favorite Scripts – 2010 Zip File |
Contains scripts discussed in the associated presentation. |
03/09/10 |
| Enkitec Exadata XMonth |
This is a presentation I did at Oracle’s X-Month training session in 2010. X-Month is an internal training session for people inside Oracle (mostly SC’s I think). |
10/28/10 |
| Back to the Future – Mainframes, Open Systems, and the New Role of Exadata |
This is the keynote presentation from the Hotsos Symposium in 2011. It’s a little out of the norm for me as it was not supposed to be a strictly technical talk, although I managed to work in a bit of info on Exadata. |
03/07/11 |
| Tuning Exadata |
This is a presentation I did at the Hotsos Symposium in 2011. It’s really a brief overview of Exadata architecture and then a discussion of Smart Scan, how it works, requirements to get it to kick in, and techniques for verifying whether Smart Scans were done or not. |
03/07/11 |
| Extreme Performance with Oracle Exadata Executive Dinner |
This is a presentation I did at an Oracle Executive Dinner in San Antonio. Here is a link to the promotional page for the event (it will probably disappear soon). |
05/03/11 |
Either deliberate from your site (what else can you tell people and make a bug), or accidental, but none of the files is accessible!
Sorry about that. The last upgrade got us. The links have been fixed now. And I see I haven’t updated this page for 2 years. I’ll come back and add links to some other presentations that have occurred since this was last updated.
Kerry
Thanks Kerry,
this will be very good addition to my Oracle docs. Update the blog once you more presentation.
sachin
[...] Kerry Osborne’s Oracle Blog » Oracle Whitepapers / PresentationsThis paper was originally presented at the Hotsos Symposium held in Dallas 2006. 02/28/06. Creative Problem Solving for Oracle Systems, Whitepaper version … [...]