Author: user

OUG Scotland DBA SIG

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

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

OUG Scotland Conference & Exhibition 2008 – Call for papers now open

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

Swingbench

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

MMON Sampling ASH Data

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

Moving AWR 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

Stats – Eek!

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!

bstat/estat Fun

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