Top 60 Oracle Blogs

Recent comments

February 2012

Repairman Jack: Legacies…

Legacies is the second book in the Repairman Jack series by F. Paul Wilson.

This book was more like a straight detective story based around a new scientific discovery. There was no supernatural aspect to the case, which was a bit disappointing. The story itself was fine, but the supernatural thing peaks my interest that bit more. I’m still happy to keep reading the books in the series, especially since they are only £1.97 on Kindle. :)



Full Table Scans and the Buffer Cache in 11.2 – What is Wrong with this Quote?

February 26, 2012 (Modified February 27, 2012) I found another interesting quote in the “Oracle Database 11gR2 Performance Tuning Cookbook“, this time related to tables and full table scans.  This quote is found on page 170 of the book: “If we do an FTS [full table scan], database buffers are used to read all the [...]


Information for members of the UKOUG:

A little while ago, the UKOUG re-organised its management to split board of directors into a board and a council. The board is responsible solely for handling the company side of the UKOUG while the council focuses solely on the services that the user group supplies to members.

Elections for seats on the council will be starting next week (27th Feb) and I have put forward a nomination in my own name. This includes a description of my involvement with Oracle and the user group, and a description of what I could offer to the user group. The nomination also include a manifesto, which I have reproduced below.

Upgrades again

I’ve just spent a couple of days in Switzerland presenting seminar material to an IT company based in Delemont (about 50 minutes drive from Basle), and during the course I picked up a number of new stories about interesting things that have gone wrong at client sites. Here’s one that might be of particular interest to people thinking of upgrading from 10g to 11g – even if you don’t hit the bug described in the blog, the fact that the new feature has been implemented may leave you wondering where all your machine resources are going during the overnight run.

DST in Russia

Daylight Saving Time in Russia has been changed last year. Oracle published a FAQ on the support site about this: Russia abandons DST in 2011 – Impact on Oracle RDBMS [ID 1335999.1].

Friday Philosophy – The Inappropriate Use of Smart Phones

I’m kind of expecting to get a bit of a comment-kicking over this one…

I never much liked mobile phones – Yes they are incredibly useful, yes they allow countries that lack a ground-based telephony network to create a nationwide system, yes they allow communication all the time from almost anywhere. That last point is partly why I dislike them. {Actually, I don’t like normal phones much, or how some people {like my wife} will interrupt a conversation to dash across the room to answer it. It’s just a person on the phone, it will take a message if someone wants to say something significant. If someone calls your name out in a crowd, do you abandon the people you are talking to, dash across the room and listen to them exclusively? No, so what act that way over a phone?}.

AIOUG Webcast:Methodical Performance Tuning Part 2

Thank you all for attending the Part 2 of the Methodical Performance Tuning series. I hope you got something out of the 1 hour long session. You can download the slides and the scripts I used during the demo here.

As always, I will appreciate any feedback which helps me in designing future content.

Call for assistance

This is a temporary note to point you to a request from James Morle for a bit of community effort. As spinning rust is gradually replaced by semi-conductor devices, transport latency becomes more significant, so James is trying to get a handle on this aspect of I/O. If you want to help build a coherent picture, read this article and see what you can do about running the test.


Testing Transport Latency

(Updated 04/04/12 to fix bug with large raw disk partitions) I need your help! One of the things that I have struggled to get data for in my storage research is the latency of the interface between server and storage device. It's easy to get numbers for the actual storage device, but the latency numbers […]