OakTable Sunday - 2nd December

Registration information

Registration for Sunday sessions were separate from the normal conference pass. Just under 100 people gained value from attending on the Sunday and found the 1/2 day of sessions very useful.

 

OakTable Sunday information

OakTable Sunday took place for a second year running on Sunday 2nd December.

In the smaller setting, delegates attended a dedicated set of sessions directly from a selection of OakTable members, away from the potential session contention of the main conference. The eight sessions were presented in just two streams.

Click here to view www.oaktable.net

Agenda

12:15 – 13:00

8-bit Oak Roots

Bernie Dugggs, Imagine Software

Keeping it Simple in Database Application Development:  A Case Study

Melanie Caffrey, Oracle
13:05 – 13:50 DUDE, Where's My Other Data?

Kurt Van Meerbeeck, Consultant
Horrid Collateral Compression

Jonathan Lewis, JL Computer Consultancy
13:50 – 14:35 Late Lunch
14:35 – 15:20 Dissecting RAT

Julian Dyke, Juliandyke.com
Guiding Practices for Gathering Optimiser Statistics (or Not)

Martin Widlake, ORA600
15:25 – 16:10 Secret Talk About Possible Future Release of Oracle Database

Christian Antognini, Trivadis AG
Tuning Untouchable SQL using Profiles

Dan Fink, TZOD Consultancy

 

Presentation slides have been made available at:

http://www.oaktable.net/oaktable-sunday-2012

 

Abstracts

8-bit Oak Roots
Bernie Dugggs, Imagine Software

There’s a reason so many Oakies are about the same age. We were the keen users of the first popular computers. The British version of that experience was based on cheap and available 8-bit home computers that unleashed people’s latent passion, talent and ingenuity in over-coming platform limitations.
Bernie Dugggs will take a nostalgic look at his personal history as a developer of commercial ZX Spectrum computer games for Imagine, Ocean and Odin and show how relevant the experiences and lessons learned have remained throughout a career in software

Back to the agenda

Keeping it Simple in Database Application Development:  A Case Study
Melanie Caffrey, Oracle

When you are tasked to create an application the questions you should ask yourself (among others) are:  How quickly can I reasonably build this application? How simply?  How can I ensure maintainability and scalability? And when (more importantly) should I opt not to reinvent the wheel?
This presentation addresses these questions and provides a case study overview through lecture and sample code.

Back to the agenda

DUDE, Where's My Other Data?
Kurt Van Meerbeeck, Consultant

This presentation discusses several cases where the data unloader 'DUDE' had to be used to extract data from crashed or corrupted databases. It will also focus on some of the algorithms used to retrieve this data, and how this data is internally stored.

Back to the agenda

Horrid Compression Collateral
Jonathan Lewis, JL Computer Consultancy

HCC is one of the "secret sauce" (or possibly "magic mushroom") features of Exadata, so it's worth taking a look at how it's implemented and what this might mean in terms of the most appropriate way to use it, and the most important reasons to avoid it.
Although Oracle will not supply any detailed documentation about how they have implemented this feature, there are a few simple steps we can take, and a few easy experiments to get an idea of what's going on under the covers, and how that might affect a production application.

Back to the agenda

Dissecting RAT
Julian Dyke, Juliandyke.com

There is little information in the public domain about Real Application Testing (RAT). It is necessary to understand what data can be captured by RAT and how it is replayed in order to interpret the results with any confidence.
In order to support a recent customer engagement I needed to investigate the internal implementation of RAT. In this session I will show how I approached this exercise and demonstrate the tools and techniques I that developed and used.
I will also discuss some of new and surprising information about the implementation and operation of the RDBMS that this investigation uncovered.

Back to the agenda


Guiding Practices for Gathering Optimiser Statistics (or Not)
Martin Widlake, ORA600

The Cost Based Optimizer continues to improve and stats gathering is now more efficient than ever - but it still seems to be that most Oracle Sites struggle with performance issues due to poor stats. It's like the annoying, embarrassing rash that simple won't go away. I will cover the options available and general principles for sorting out the stats issue, which should lead to more stable and good performance ie a more comfortable life . This should calm the annoying rash and give you some potential treatments should it flare up again.

Back to the agenda

Secret Talk About Possible Future Release of Oracle Database
Christian Antognini, Trivadis AG

Abstract to be confirmed shortly

Back to the agenda

Tuning Untouchable SQL Using Profiles
Dan Fink, TZOD Consultancy

One of the greatest challenges with Oracle performance is the optimization of SQL plans, especially when faced with 'untouchable' application code. SQL Profiles, introduced as part of the SQL Tuning Advisor in 10g, offer the ability to influence the optimizer without changing the SQL or application code. This session will present an overview of SQL profiles, how to implement them both manually and using supplied tools and monitoring them for usage.

Back to the agenda

 

back to Agenda Highlights

 

Top