Category: Uncategorized

In a previous blog I mentioned that Julian Dyke had talked about these views during his presentation and I noticed Jonathan Lewis also includes it in an Appendix of his new book that I started reading last night. There are three versions of the view Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 – 64bit… Continue reading 10g Optimiser Environment Views

They’re not all on there yet, but some more reading matter for those of you who couldn’t make it to the conference. http://www.oaktable.net/userFiles.jsp Cheers

You wait a while for one to come along and then get two at the same time. While looking at Technorati links from Andy C’s blog, I noticed another one I’ll be revisiting. http://www.lifeaftercoffee.com/ might not be as funny as Andy’s but the subject matter is right up my street – mainly DBA-related – and… Continue reading Good blogs are like buses

My copy of Jonathan Lewis’ CBO book should be with me tomorrow 😉 In the meantime, as I expect to be blogging pretty often about the process of setting up the Intel ISP4400 that I bought to use for experiments at home, I thought I’d better hive it off into a seperate blog. I worry… Continue reading Cost-based Oracle and ISP4400

One of my old Sun colleagues, Jari Kuhanen, mentioned to me that he hoped to see more tips from the UKOUG conference appearing on blogs. Sadly, the few notes I made might as well be in Greek for all the sense they make to me when I read them, but hopefully I’ve got this one… Continue reading A better INDEX hint

I’m a bit disappointed. I was very impressed that Howard Rogers’ blog emailed me whenever someone commented on a blog that I had commented on earlier. I thought this was the result of some Dizwell magic so I emailed Howard to find out how it was done, but it turns out that it’s one of… Continue reading bloghi.com

As I mentioned in a previous blog, I learnt something new from Anjo Kolk’s SAN presentation at the Oak Table day at the UKOUG conference. Instead of looking at the maximum read time for a file since the instance started or the average in a statspack report, you can reset the maximums. SQL> select *… Continue reading Resetting v$filestat timings

Because, what else would he be called? Now that I’m back from the UKOUG conference and I’m unlikely to bump into anyone from the Oracle community for the next few months, there’s been a power-struggle in the house to see who should be next up for the free photo publicity. Geoffrey, as you can see,… Continue reading Geoffrey

I noticed Andy C’s blog from a comment he posted here and enjoyed a good few minutes of fun and opinionated reading. I’ve added the link to the sidebar. http://andyc.wordpress.com

Sorry, but I have to blog about this. When I got home last night, my other half wouldn’t shut up about Telewest cable tv’s new Teleport TV that appeared out of the blue yesterday. It’s like a low-functionality Tivo. i.e. We don’t have our own hard disk recorder, but Telewest run repeats, movies and the… Continue reading Telewest’s Teleport TV