Author: user

In an earlier blog I talked about saving optimiser statistics and suggested that there are a couple of approaches to viewing saved statistics. It’s not rocket science to view the contents of the stats table directly, but Oracle could change the format over time, so it’s probably best to use the supplied procedures for accessing… Continue reading stattab contents

“They’re coming home, they’re coming home ….” I missed England being knocked out of the World Cup. The tootache returned with a shocking vengeance on Friday night and although it had calmed down by Saturday afternoon, I obviously needed more recovery time. I did watch the match, but fell asleep as it became clear injury… Continue reading ‘England out of World Cup’ shocker!

Is it just me or is there an error in the Reference Manual? We were having a problem with enormous trace files being generated, so wanted to limit the size system-wide. Although I’m generally used to specifying this in blocks, I thought I would try specifying it in Mb. 920> show parameter max_dumpNAME TYPE VALUE————————————… Continue reading max_dump_file_size

Eventually, you start to run out of titles to say ‘here are a few links I’ve been looking at this week’ 😉 I enjoyed the debate about the value and dangers of the Internet over on Tom Kyte’s blog. There are aspects of both sides of the argument I agree with but there has been… Continue reading What’s going on out there

I hate visiting the dentist. I hate strangers sticking needles into my gums in particular. It therefore seems obvious to me to visit once every four or five years, when I’m in serious pain. If pain-killers still work, it’s not serious enough. If those nearest to me threaten to kidnap me and drag me to… Continue reading Dentists

Once I’ve got tonight’s on-call out of the way, I’m flying down to London in the morning for a weekend away with one of my mates, my other half and her sister. I’ve hummed and hawed about it but think I’ve decided to leave my laptop at home, which’ll mean no blogging or email for… Continue reading Off to London

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