Category: Uncategorized

I should get to bed soon because I have to be up at 4am for my flight to Stockholm (via Copenhagen). Tomorrow (and on Wednesday) I’ll be presenting at the Swedish and Finnish Oracle User Groups joint 20th Anniversary event on the good ship (I hope) m/s Silja Serenade. The nearer the event, the more… Continue reading Conference Activities

An enjoyable day, but it flew by. Having not had much sleep last night through worrying about the first time I was giving this particular presentation, I’m glad I was able to present in the second slot of the day because I knew I’d be flagging later on. The most enjoyable aspect of Scottish events… Continue reading OUG Scotland DBA SIG

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… Continue reading Upcoming Events

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 & ExhibitionDate:        Wednesday 8th October 2008Location:  Radisson SAS, Glasgow For details of this year’s event, including all information and to make your submission, please… Continue reading OUG Scotland Conference & Exhibition 2008 – Call for papers now open

A short post in praise of Swingbench. (There’s much more information at that link.) Without this utility, demonstrating performance problems during the course would have been much more difficult so I owe Dominic Giles. It’s simple to set up using one small configuration file to set up environment variables, a JVM and an Oracle client… Continue reading Swingbench

When I was working on the course, I noticed this White Paper (PDF) on Oracle 10g Self-Management Framework Internals: Exploring the Automatic Workload Repository. The paper describes the way that MMON selects 1 in 10 of the ASH samples for storage in DBA_HIST_ACTIVE_SESS_HISTORY (I suppose it would be more correct to say WRH$_ACTIVE_SESSION_HISTORY_BL) :- “The… Continue reading MMON Sampling ASH Data

Note – features in this post require the Diagnostics Pack license [I originally had the first section at the end of the blog post, but then realised I might as well get the bad news out of the way to save you wasting your time if you’re not interested] A small section of the course… Continue reading Moving AWR data

I’ve been playing around with utlbstat.sql/utlestat.sql, only briefly I should add, for a short section on the history of Oracle’s performance tuning utilities and I noticed a couple of things that tickled me enough to blog about them. First, as the scripts output the comments, I noticed that quite a few of the updates to… Continue reading bstat/estat Fun

I’d noticed that the author name wasn’t showing up properly in the feeds from this blog so I went to investigate why. I logged into Feedburner (a rare event) and noticed these subscriber numbers. I’m quite shocked. I only look in Statcounter sometimes to see where people are coming from and I get weekly Statcounter… Continue reading Stats – Eek!

…. but I don’t think so. This one definitely is. I’ve *seen* Richard 😉