Author: user

I can’t access any of my favourite wordpress.com blogs. It must be all of those ex-Blogger Oracle types putting strain on the servers 😉 Hopefully the problem will be solved soon

… and quite funny. I followed an incoming link through Statcounter and arrived here. At the moment, the content is :- SQL> startup mountORACLE instance started.Total System Global Area 645922816 bytes Fixed Size 1250644 bytes Variable Size 184552108 bytes Database Buffers 457179136 bytes Redo Buffers 2940928 bytes Database mounted.SQL> alter database open;Database altered.

I was looking at some screwed-up old technical blogs last night and realised that —- is probably not the greatest content seperator on a blog import tool. Not if you have sqlplus examples in them, anyway. I’m sure you can work out why not, but if not, just look for an old blog with such… Continue reading That would explain it

In my previous blog I showed how you can save your current optimiser stats into a seperate table whenever you refresh them, so that they can be restored should the new statistics lead to poor SQL execution plans. Oracle have added an improved version of this facility to 10g (which I take as a sign… Continue reading Saving Optimiser Stats – 10g

Through a combination of dragging my content out from under Google’s nose and not having the Statcounter code implemented across the blog, things aren’t looking so good 😉 Hopefully both situations are resolved. Just a bit more tidying up to do and then I can get back to the World Cup Oracle.

I’m concerned. There have been a couple of occasions since the start of the World Cup when a player has been tackled heavily (or hardly touched) and, in addition to flying several feet into the air, performing a double twist with pike and coming crashing to the ground in apparent agony, he has yelled out… Continue reading Aiiiyyyeeee!!!!

I’ve received at least four emails and blog comments that amount to ‘Why on earth would you choose Serendipity when WordPress is the best’. So, because I want to nip this in the bud and hopefully never comment on it again, here goes. 1) It wasn’t a big decision where I evaluated the possibilities. I… Continue reading Serendipity

Although a work in progress, I’ve taken Howard’s advice and reintroduced the template chooser, but with a much reduced number of options, including one I’ve tweaked myself. I plan to improve this as time passes but, for now, there are four options including one serif font option. Nothing too exciting, but hopefully one of them… Continue reading Templates

Well, only one new blog really. Stephen Barr is a guy who I’ve been dealing with at work. He’s a Data Warehouse specialist, part DBA, part designer, part developer. (There’s a blog coming some time soon on the various Oracle roles in the modern business.) He’s a contractor, too and we’ll be going in our… Continue reading More blogs

On Saturday morning, we ran into a problem on one of our 9.2.0.7 Production databases during an Extract, Transform and Load (ETL) batch process. I was called at 5:15am to look at a job that normally runs in a few minutes but had failed after 30 or 40 minutes when trying to allocate an extent… Continue reading Production Call-out