Daily Archives Tuesday, August 2008

Something Cool

I wanted to share some eyecandy from my Ubuntu box. I found this phenomenal desktop image (hat tip Lifehacker), and when combined with the terminal app’s transparency setting, it creates a pretty cool effect, especially when you drag the terminal window around the desktop and the background changes.

Another cool effect is opening the terminal over [...]

Hotsos Symposium 2009 Call for Papers

The Call for Papers for Hotsos Symposium 2009 is now open. To submit an abstract proposal for the event, please visit the Call for Papers page. The call will remain open until 24 October. This is your chance to get your name on the agenda and earn a co…

Social Observations, OraTweet Edition

I’ve spent a bit of quality time with Noel’s OraTweet this week, mostly because of Ed’s OpenSocial app development adventures.
Noel really has done a lot with OraTweet since June, when he first showed it to me. It’s got all the Twitter features you’d expect, and it has “groups”. Don’t get too excited, it’s more like [...]

Resolving Fan Traps and Circular Joins using OBIEE

If you’re looking to migrate data from a Discoverer system to Oracle Business Intelligence Enterprise Edition, one of the first things you’ll probably end up thinking about is how your (not necessarily star schema-based) End User Layer will translated to a (star schema mandatory) Common Enterprise Information Model. In particular, Discoverer allows tables to have [...]

SORTs, TIMEs and 11g

A while back I noticed that the TIME values in the STAT lines for an 11g Database weren’t adding up right if there was a sort operation in the plan. I talked with several folks and everyone agreed that this was going on but no one seemed to know why. …

A non-Oracle post: productivity and online note keeping with n.otepad.com

I haven’t written a non-Oracle post into my blog yet, so here’s one for you :) I recently developed a little web service with a friend. Shortly, check out http://n.otepad.com and any feedback is appreciated (especially about the parts which suck, so we could improve those :) The longer story is that for years I used to [...]

Update on my whereabouts

I know I haven’t posted much recently. I’m posting this from my blackberry in Iowa City, Iowa. I was in Chicago yesterday. I don’t have my laptop with me on this trip so I feel waaayyyyyy out of touch.

I’ll have some good topics to write about soon. I’m able to spend some time on warehousing topics now (that is the focus of my job now) so that will be a major focus for me on the blog, too.

I have not been able to dowload and clean up the survey data as of yet. I’ll be back in tampa on

Flexible sampling of any V$ or X$ view with sample.sql

In recent past I’ve blogged few scripts which use specially crafted ordered nested loop for sampling contents of V$ and X$ views fast, with plain SQL.
If you haven’t read them yet, here are the links:

WaitProf
LatchProf
LatchProfX

I wrote the above scripts having special purposes in mind (e.g. profile session waits or latching activity).
Now I introduce a simple [...]

London calling

So now the whole world knows what living in London is really like.Clamouring with a crowd of 15 cosmopolitan, wackily dressed people, pushing and shoving trying to get on a red, double decker bus having waited 45 minutes. With some idiot playing Led Ze…

twitter killed the blogging star

I have tried many times, in many different places, to articluate the idea that micro-blogging reduces ones blogging output but Russell Beattie completely expresses my thoughts on the subject in this brilliant article.’Tweeting totally takes away that b…