Author: user

Just in case you miss it … Jonathan has an interesting new piece on sort efficiency in 10gR2. What struck me on reading this is that, no matter how mature the CBO may be, small improvements are constant. That tells me that it’s a mistake to rely on an optimiser to do everything well and… Continue reading Jonathan Lewis on 10gR2 Sort efficiency

It’s a bit of a blog frenzy today! On the 3rd November last year, immediately after the UKOUG conference, there was a seminar in Edinburgh to discuss temporal databases. (Mogens blogged about it here and I’d mentioned some of Rob Squire’s work here.) I had planned to go initially but was unable to get the… Continue reading Peter Robson on the Temporal Database seminar

This one is courtesy of Andrew Campbell at Sun Microsystems. He noticed in an Oracle Magazine article that you can use a URL as a script name in sqlplus. SQL> select * from v$version;BANNER—————————————————————-Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – ProdPL/SQL Release 10.2.0.1.0 – ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows: Version 10.2.0.1.0 – ProductionNLSRTL… Continue reading Something Else I Didn’t Know

It’s all too believable. Sitting in my Inbox is this mail to myself on 19th Dec with a list of future Blog ideas Yahoo Mail Beta and MetalinkSage, Tatung Einstein and a nice website :-http://www.old-computers.com/museum/computer.asp?c=607&st=1http://www.old-computers.com/museum/computer.asp?c=647&st=1http://www.old-computers.com/museum/computer.asp?st=1&c=86 I thought I might get round to these when the holidays were over (I was trying to be a good… Continue reading That Damn Kyte!

Well, it’s officially my birthday now. I’ve had more birthday wishes than I’m used to, then I came across this. (I’m mentioned some way in to an interesting blog) http://stephensorablog.blogspot.com/2005/12/almost-all-users-are-idiots.html I tend to have a terrible memory for course students (I met a lot in quick succession) but I remember Stephen and I’m chuffed that… Continue reading My lucky day

Tomorrow is the final day of 2005 and my 40th Birthday. The next day I fly to New York for a one week celebration. How a group of Scots decided to check in at 7am for a 9am flight on the 1st January is still something of a mystery to me. (To be honest, it… Continue reading So long 2005 and thanks for all the memories

Rob Vollman blogged about the Thomas Kyte Effect. Pete has (and no doubt others have) before. Well, I have to say I’m a little disappointed and I’m thinking of writing to Tom and asking for a refund (and perhaps he can make Metalink run faster while he’s at it). I noticed a link to my… Continue reading I want my ‘Thomas Kyte Effect’!

I think I’ve got to the bottom of the underwhelming Tom Kyte effect on my blog. I remembered that about the same time as Tom linked to my blog, I swapped Bill in as my new avatar! I knew he was pretty scary but he’s not that bad … Actually, he is, isn’t he?

I noticed the following blog as an incoming link on Statcounter http://oracletoday.blogspot.com/ When I went to take a look, it turns out that SQL*Net message from client had been a blog subject back in September. It’s worth taking a look at another example of how this ‘idle’ event can be a sign of problems in… Continue reading I swear I didn’t know

I can’t promise this means I’ll be quiet until January, but The Boys (and Girl) insisted on wishing everyone happy holidays and a hopefully peaceful New Year. Have a good one …