A reader of this blog, Paresh, asked me how I was able to find out the logic behind ITL waits without having access to Oracle code. My reply was: I wrote a test case that reproduce ITL waits and a piece of code that monitors them.
Since other readers might be interested, here is the shell script I wrote. Notice that it takes four parameters as input: user name, password, SID, and how long it has to wait in the monitoring phase.
June 19, 2011 Currently, the most viewed article in the past 90 days on this blog demonstrates a deadlock situation that is present in Oracle Database 184.108.40.206 and above that is not present in Oracle Database 10.2.0.1 through 10.2.0.5 (someone else might be able to check the earlier releases). This particular deadlock was the result of [...]
Just a few random notes. Oracle Mix have the Oracle OpenWorld 2011 Suggest-A-Session again this year with lots of good presentations as always. Follow the link to vote for my Q & A session on Oracle Indexing. Jonathan Lewis has an interesting quiz on Oracle Indexes in answer to a question from the OTN forums: “If I delete [...]
What’s the best way to make a presentation on Agile practices? Practice Agile practices.
You could write a presentation “big bang” style, delivering version 1.0 in front of your big audience of 200+ people at Kscope 2011 before anybody has seen it. Of course, if you do it that way, you build a lot of risk into your product. But what else can you do?
You can execute the Agile practices of releasing early and often, allowing the reception of your product to guide its design. Whenever you find an aspect of your product that doesn’t get the enthusiastic reception you had hoped for, you fix it for the next release.
I’ve said it before and I’ll no doubt say it again, but the mark of a good superhero film is you should be watching it thinking, “I wish I was
As a fat 41 year old man, that is exactly what I was thinking whilst watching Green Lantern. If Iron Man is a 9.5/10, then this is somewhere around the 8.5/10 region in my opinion. Similar to Thor I guess.
Parts of it reminded me of Spawn. I found myself thinking, if this character had watched the Spawn movie he could manifest some better weapons and defenses.
If they do a sequel, it would be cool if they focus on some of the other Lanterns.
It’s official – I’m writing a new book for Apress.
The working title is: “A look at the internal mechanics of the important bits of Oracle for people who aren’t planning to become rocket scientists but who do want to do a little more than just push buttons in OEM”. (I’m still working on making the title a little more catchy.)
Target publication time – some time in November.
I got a mail from long time Oracle guy Joel Garry regarding the twitter widget in the right hand column.
On orawin.info, you have a twitter feed, where each entry has a date/time link on it. But those links look like http://twitter.com/nlitchfield/statuses/8.0773403426E+16 which look to me like something is translating a big number to scientific notation…?
Well Joel was right. Something was translating a large number to scientific notation. That something turns out to be php itself. Twitter status updates are (apparently) a simple ever increasing integer. There are now a lot of twitter status updates. As this page shows recent versions of php will automatically display that in scientific notation unless explicitly told otherwise. Now I personally think that this is an odd thing for php to choose to do, but us database folks surely recognize the folly of the plugin programmers relying on default formats. Anyway my version of the plugin is now fixed – based on this forum post - and thanks to Joel for the heads up. Anyone reading this who programs in php against databases that might return large numbers might wish to reveiw their web pages for appropriate results.
I’ve been having a 10 year anniversary of internet publishing for the best part of a year now.
I started publishing scripts and articles on the internet some time early in 2000, so really my 10 year anniversary was some time last year. I can’t remember the exact date though.
The first time my site appears on the Way Back Machine is June 2001 under the name tshcomputing.com. Since this is the first recording I can find of the site, I guess it means it was off the search engine radar before then, so this could be considered the official start of the site (as seen by the world), making this my 10 year anniversary right about now.
I started this blog in June 2005, so it’s only my 6th anniversary of blogging. That’ll be another 10th anniversary in a few years time then.
I think I’ll stick with 2000 as being the start of it all because I’m getting old and it’s easy to remember. How times flies when you’re geeking out…