Top 60 Oracle Blogs

Recent comments

Oaktable Sunday 2012

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

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.

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.

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.


Dissecting RAT
Julian Dyke,

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.

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

Abstract to be confirmed shortly

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.

8_bit_oak_roots.pdf879.49 KB
ukoug2012_dude.pdf487.29 KB
stats_gathering_oak_121202.ppt1.02 MB