Author: user

It looks like Oracle-WTF has been kidnapped. If anyone has William’s email address to hand, perhaps they could let him know? 🙁

After solving the jigsaw puzzle and waiting for tape drives to do their thing, we’ve finally got a running test instance accessing a full copy of production. (Well, there was some recovery, faffing around with database names, control files, tempfiles, putting the database in noarchivelog mode and the rest, but there are plenty of Oracle… Continue reading Full Volume Database Refresh – Part 3

First the good news. “The Refresh from Hell” (because it was) has become “The Slightly Tricky Refresh“. It only took 6.5 hours on Sunday (in time to watch Celtic’s first match of the season) and apart from a couple of minor panics along the way, it went well. Anyway, back to the overall process, with… Continue reading Full Volume Database Refresh – Part 2

(… or the Refresh from Hell) This weekend will be the final practice run (there’s been one already) for a database refresh procedure I’ll be working on for a further four weekends. It’s a full copy of one of our production databases that forms part of a user acceptance test environment for a significant application… Continue reading Full Volume Database Refresh – Part 1

… and walk away. In the course of the past year, I’ve heard more than one person suggest that Jonathan Lewis should stop debunking Don Burleson’s arguments. Their opinion is that it makes Jonathan look narrow-minded and spiteful and that he should simply ignore Don, stop giving him extra publicity and he’ll go away. Here’s… Continue reading Why you can’t just say ‘Stop feeding the troll’ …

I’m very late to this particular party (things move quickly these days) and I was going to jump into this discussion several times this week because it’s a subject dear to my heart, but you know how it is – work etc. First of all I noticed Kevin Closson’s blog and the associated thread on… Continue reading OTN and Development Licenses

I’ve been asked this question at quite a few sites so thought it would be worth blogging about. (The fact that it’s a common question also implies that any criticism is aimed at the industry rather than individual companies or colleagues.) Someone, usually a manager, wants to see the workload history for each instance in… Continue reading Oracle Workload Metrics

Over here. Please do not start any Cuddly Toy Front campaigns. They have a new home, they’re quite excited about it (at least that’s my story) and the next post here will be about Oracle, honestly!

Here are a few interesting blog postings I’ve been reading this week. Jonathan Lewis on another Statspack example. Nuno Souto on SQL Server – in three parts. What I particularly like about these postings is that the man has used both and is honest about their relative strengths and weaknesses, rather than sticking to the… Continue reading Today’s Links

I don’t know how this will go and it could be a bad idea, but I’ve been thinking about it recently. I’ve decided to fork the blog. Why? Well, I’m aware that a lot of what I write is just gossip, rants and nonsense, basically. Part of me understands that can be perfect blog material.… Continue reading fork (2)