Daily Archives Sunday, April 2008

Upcoming Events

I’ll be presenting at a few events in the next couple of months.

30th April - OUG Scotland DBA SIG Meeting.

This one is the easiest for me to travel to, being just on the out-skirts of Edinburgh, and is always a well-organised event with a decent agenda, thanks to the local committee.

20th-22nd May - Swedish and Finnish User Groups joint anniversary conference.

This looks like being a very exciting event to celebrate the 20th Anniversary of the user groups, taking place on a cruise ship which should add a unique atmosphere to what already looks like a very strong agenda.

19th June - UKOUG Northern Server Technology Day.

Lisa Dobson, amongst others, has constantly tried to improve the UKOUG’s profile of events in Northern England (we do ok in Scotland already ;-)) so I always try to make this event when it runs. It’ll be just a short train journey away, too ;-)

At all three events I’ll be presenting "How I Learned to Love Pictures’ which is my attempt to try to capture my growing love for the OEM Performance Pages in OEM Database Control/Grid Control. I’ve always had a soft spot for them but spending a few months messing around with them for the Oracle seminar and for implementation at my current site has reinforced my initial impressions. Although there will be some vaguely technical content, there are going to be very few slides. What I want to do is show how pretty and useful the tools are by using some of the demos from the seminar. I’m convinced that people can only fully appreciate the tools by seeing them in action. Fortunately all three presentations have a one hour slot which will give me enough time for a few demos and hopefully some questions too.

On the boat trip, I’ll also be presenting the OFA-related presentation from last year’s UKOUG conference in Birmingham, although I’m thinking of improving the technical content.

So, quite a bit for me to look forward to.

Manual Optimisation

The following question appeared in a recent post on the Oracle DBA Forum.
We have a developer here who thinks that DBAs can make things happen. His query is against a single table and his result set is around 300,000 records and he wants to sort this by two columns (transaction_id desc, id desc) where id is [...]