Author: user

I’m working on our script to change the oracle owner unix account password across our server estate at the moment and it occurred to me it might be worth mentioning the expect utility for anyone who might not have come across it. It allows you to write scripts that automate ssh, ftp, telnet (etc.) sessions.… Continue reading Great Expectations

http://news.bbc.co.uk/1/hi/scotland/glasgow_and_west/5290278.stm http://news.bbc.co.uk/1/hi/scotland/glasgow_and_west/5292948.stm

There’s been lots of chat in the Blogosphere (that link’s one of many – here’s another) about the upcoming Openworld conference and I know a few people who’ll be attending. Personally, because all of my trips are self-financed (including the time off), I need to make decisions about which conferences I can afford to attend… Continue reading My Openworld Story

You have to laugh. Yesterday I received a mail-shot from Apple Frustrated with your PC? Time for a Mac. In the past 30 days has your PC: A. Crashed B. Frozen C. Made you want to pummel your screen with a sledgehammer D. All of the above It just works. Another great reason to own… Continue reading An Open Letter to Steve Jobs

or … ‘what’s that all about?!?!’ Last year, I blogged about some of the variations on Optimal Flexible Architecture that I’ve seen on my travels. I’m gradually coming round to having the service group for clustered applications as the top directory level (e.g. /myapp1/oradata//myapp1/oraindex//myapp2/oradata//myapp2/oraindex/ but I’m still not convinced. If people ever failed over individual… Continue reading 10g Default Installation and OFA

At the moment I’m writing a short 9i/10g New Features seminar for the developers at work. The idea is to run through lots of new features very quickly to see if anything lights their candle and they can then go off and investigate further afterwards. It occurred to me while I was putting some slides… Continue reading Resumable Storage Allocation

A while back, I implored Anjo Kolk to start posting to his blog again. I suspect it’s completely unrelated, but he’s back 😉 Cool.

THE FINAL UPDATE – 21st August 2006 Template Issues? I don’t think so! More like user error 😉 It turns out that all of my template/RSS/blog problems were self-inflicted because I’d stupidly renamed my templates/default folder to something else. What I hadn’t realised was that, a bit like the DEFAULT profile in an Oracle database,… Continue reading Template Issues

The AUSOUG and OAUG committees are very excited to announce the Australian 2006 conference series is less than three months away. While our American neighbours are focusing on Oracle OpenWorld in October, and our UKOUG friends on their (extended!) November conference, Australians will not miss out with the largest Oracle user group conference in Australia… Continue reading AUSOUG/OAUG 2006 Conference Announcement

Previously I talked about the importance of historical perspective to server performance tuning, but it applies to many areas of working with databases. For the last part of this mini-series, I thought I’d pull together a few more examples. Execution Plans and Optimiser Statistics I’ve written several blogs recently about the value of keeping a… Continue reading Historical Perspective (Part 3)