Production database was upgraded to 11g over the weekend: 9i -> 11g, SE -> EE, Windows -> Linux.
This is the first application in this client’s company to upgrade.
Seems to have gone well given that I was not called over the weekend.
As ever though, the only true test is going live and I would be [...]
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.
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 [...]
I’m a big fan of the Oracle documentation, but sometimes things go astray. A recent question by Aman Sharm about SQL sharing critera highlighted this…
In the 8iR3 manual, the decision process for finding matching SQL is listed as:
The text string of an issued statement is hashed. If the hash value is the same as a [...]
Following the success of OUG Scotland Conference & Exhibition 2007 this year’s event is expected to be even bigger with over 250 delegates and eight exhibitors.
Event: OUG Scotland 2008 Conference & Exhibition
Date: Wednesday 8th October 2008
Location: Radisson SAS, Glasgow
For details of this year’s event, including all information and to make your submission, please visit the OUG Scotland website: Click here
Submissions must be received no later than Friday 13th June 2008 for selection to be carried out by the committee. Notification of whether the paper has been selected or rejected will be received by end of June - mid July.
If you have any queries or are unsure of any aspect of this please feel free to contact aimee@ukoug.org
I’ve been doing a lot of traveling recently, which as usual means that I’ve been doing a lot of reading. I normally take a novel with me when I’m on the road but based on some recommendations, I’ve been working through a batch of books on business analytics. First off was “Competing on Analytics”, the [...]
Here’s an interesting point that’s just been raised on from the Oracle-L list-server:
Metalink bug: 5483301.8
If a column has a frequency histogram and a query uses an equality predicate over the column looking for a value that does not exists in the histogram then the CBO was estimating a cardinality of 1. This could favor Nested [...]
If you are reading this it means my blog has been upgraded to the latest release of WordPress (2.5.1).
Cheers
Tim…
Earlier on this week I’ve been delivering some BI Publisher classroom training, with a day at the end for one-to-one sessions with the delegates and some consulting. One of the requirements that came up from the customer was for a report to split the various pages within it to different trays in the printer, so [...]