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
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.
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.
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.
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.
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.
Abstract to be confirmed shortly
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.