Search

OakieTags

Who's online

There are currently 0 users and 33 guests online.

Recent comments

Affiliations

March 2012

VirtualBox 4.1.10 Released…

I, for one, welcome our new VirtualBox 4.1.10 overlords…

See changelog

Happy upgrading.

Cheers

Tim….




John Carter…

It’s been a while since I’ve been to the cinema. I’ve been checking the listings regularly, but nothing has caught my interest. Yesterday I saw an advert on some website for John Carter which caught my eye. The name of the film sucks, which is probably why I never noticed it before, but after seeing the trailer I though it was worth a shot.

I really enjoyed it. The story is pretty neat, provided you don’t try to analyze it for more than a second. The visual effects are fantastic. There is a cute dog/lizard/monster thing that I really want. The leading lady is hot. Most importantly, it doesn’t take itself too seriously.

I went to see the 2D version, but Noons said the 3D version was good too.

If you like Sci-Fi movies I think you will like it.

Cheers

Tim…

Thoughts on a Hyper-Extended Oracle Performance Monitor Beta

March 12, 2012 As long time readers of this blog might know, in my free time during roughly the last 10 years I have been working on a program named “Hyper-Extended Oracle Performance Monitor”.  Since 2005 or 2006 I have permitted a few people to try the beta versions of the program, thinking that I might [...]

Half Price

Another book offer from Apress.

I can’t find any online confirmation at present, but until the end of this week (19th March) it seems that promotion code SXSW12 will get you all the Apress eBooks you want with a 50% discount according to this posting on the Oracle-L list server: http://www.freelists.org/post/oracle-l/SemiOT-Halfoff-Apress-ebooks

Windows 8 Rant Continued…

One of the comments on my  rant about Windows 8 suggested this might be a good thing for desktop Linux. I just don’t see it myself. The only people I know who run desktop Linux are techies or immediate family members of techies. I don’t see this changing any time soon. Why? The same reasons that have been used for years…

Analysing Row Lock Contention with LogMiner

Recently I had to analyse a row lock contention problem that can be illustrated by the following test case:

First_rows hash

Just like my posting on an index hash, this posting is about a problem as well as being about a hash join. The article has its roots in a question posted on the OTN database forum, where a user has shown us the following execution plan:

Mac|Life and Tom Kyte

I usually have my nose in my Kindle or iPad while traveling, but there's always the time between take-off and 10,000 feet where electronics are verboten where I need something to occupy my time. As my time filler, I will often pick up a magazine to read and on yesterday's trip home from the Hotsos Symposium in Dallas, I grabbed a Mac|Life magazine to read.

Windows 8 Consumer Preview : Complete Abortion!

I wrote some time ago about the Windows 8 Developer Preview, which I didn’t like at all from a desktop perspective.

Today I installed the Windows 8 Consumer Preview. What a complete abortion of an operating system! I thought the developer preview was bad, but it’s like they’ve taken all the comments people made about that steaming pile of crap, given everyone the bird, then made it even worse just to spite them.

Now let’s get this straight. I’ve never used Windows 8 on a phone or on a fondle-slab. It may be awesome on those, but I’ll probably never find out. I’m talking here about a desktop machine with a keyboard and mouse.

Index Upgrades

Listening to a presentation by Paul Matuszyk on extended statistics yesterday, I learned something that I should have spotted ages ago. Here’s a little demo script to introduce the point:

create table t1
as
with generator as (
	select	--+ materialize
		rownum id
	from dual
	connect by
		level <= 1000)
select
	rownum			id,
	mod(rownum,100)		n1,
	mod(rownum,100)		n2,
	mod(rownum,100)		n3,
	lpad(rownum,10,'0')	small_vc,
	rpad('x',100)		padding
from
	generator	v1,
	generator	v2
where
	rownum <= 1000000;

create index t1_i1 on t1(n1, n2, n3);

-- collect stats, no histograms.