A very quick note – there’s a very long one on Streams coming, with real code and everything, to say that Carl Backstrom’s family have updated his blog with details of how to give in memoriam to this most excellent technologist and evangelist. Go here and donate appropriately please.
I recently spent a rather pleasant day at the scottish conference of the ukoug. This was held at the Radisson SAS Hotel just by the central rail station and split into a number of streams, from management through to dba. The organisation of the event was excellent, particularly given the fact that some of the [...]
I’m just starting an installation of Oracle APEX 3.1.1 into one of our development ebs instances for 2 reasons.
To provide a small applet to a project team
To provide the infrastructure for the dbas to write their own little applets.
I chose this method for the following reasons (unordered)
it’s fairly cool
we know pl/sql much better than java
Or should I say ‘Brum’?
Well, I’ve just been notified that one of my abstract submissions, “Introduction to Locks and Enqueues”, has been accepted by the UKOUG for the 2008 Annual Conference, coming up in December. I’m really looking forward to it. This will be my 4th year attending. It’s also the first year the conference will be expanded to a full 5-day week. There’s bound to be a ton of great material. I have to say, even for someone coming from overseas, this conference is well worth your time and money.
See you in Birmingham, er, Brum!
A good day today. I was privileged enough to be at the paper selection day for the UKOUG conference in December 2008. For those who don’t know what happens, and perhaps suspect some sort of elite giving themselves presentation slots, here is roughly how it works.
Firstly a reasonably large group of reviewers from around the world, [...]
This started as a comment, but grew a bit. I suspect that most of the time the ‘difficulty’ lies in step 1. Identifying a problem that is causing drag on your employers business. This requires at least:
IT staff are notoriously bad at 1) and 3) and business staff are notoriously bad at 2) and 3). For example some colleagues of mine went to a meeting with business users of a core system that has historically suffered significant downtime. We identified and made some infrastructure changes that have reduced the downtime by approximately 40 days a year (that’s right this system was running at circa 80% availability). The system has been running in it’s new configuration at over 99% availability, and helpdesk calls have all but vanished. The meeting was quite difficult since the business users wanted to complain about the stability of the system. In particular they were upset with the 99% availability statistics because they felt that the stats did not reflect reality, which was that occasionally data was ‘lost’ or application sessions were apparently hung. The fact that other users could continue to work did not mean that the service was available.
I’ll get to the point in a minute… If you’ve spent any time “working” on setting up a home theater in your home, you’ve come across the WAF acronym in many of forums — it stands for Wife Acceptance Factor — and it is a cautionary tale of making sure you keep your setup easy enough so that you don’t end your marriage over your wife’s inability to enjoy Desperate Housewives because she doesn’t like programming the remote
Back before HDTV and satellite TV it was pretty simple here in the US to set up and watch TV. Generally there was only 1 cable involved (2 if you count the power cable). If you bought a cable-ready TV you simply connected the cable from the cable company (RG6 coaxial, which carried both audio and video) into your TV and you were in business. Moving TVs around your house was pretty simple too. Oh, maybe you had a converter box to watch some pay channels, but for the most part you were good to go — with maybe 50-75 channels in the larger markets.
Things are getting a bit easier lately, but we’ve had a run of complication which I think has seriously slowed the adoption of HDTV and quality sound — the split of audio and video cables — the larger number of cable choices audio-only (optical, coax, patch); video-only (patch, coax, dvi) and mixed (hdmi) along with wonderful new things to learn about like HDCP and DRM. None of which has made it any easier to make a TV have a good WAF anymore — let alone move them around your house.
The reason I bring this up is due to the shear number of software offers I’ve been getting lately for products that don’t seem to have a compelling ability to simplify things for me or my customers. They claim to be “better” at some esoteric task, but at the cost of introducing another specialized skill requirement into my customer’s infrastructure.
I got into an interesting discussion with a virtualization consultant the other day who responded to a customer’s concern about the I/O performance of a database on VMWare by installing Virtuozzo for a special system. I asked why they did that instead of looking to tune the database I/O or maybe scaling up the VMWare hardware or (gasp!) running the database on a dedicated server. He replied that he recommended Virtuozzo because they wanted everything virtualized and that they didn’t have budget for tuning or new hardware.
Heck, I like Virtuozzo as a virtualization solution and even I thought this solution was all kinds of crazy.
Why add to the customers’ complexity by introducing yet another virtualization technology instead of helping them reduce complexity while still meeting their needs? The only beneficiary to this appears to be the consultant who can charge fees to maintain this specialized system. Or maybe the new employee they had to hire to learn and handle this special system.
Personally I got even more upset when I heard that the customer was a public school system — like a public school system needs internal IT complexity instead of simple, reliable systems that do the best job for them.
One-off’s like this are always a challenge — make sure you have a process by which you approve, manage and judge such efforts — understand when one-offs become your new direction, or when they need to be brought back into the fold.
I ran into a situation over the weekend, where an application and schema, which were stable under 10.2.0.3, started hitting ORA-00060 deadlocks in 126.96.36.199, in spite of the fact that no application code changes had occurred. It seems that 11g was more sensitive to deadlocks in this situation than 10gR2 was.