Search

Top 60 Oracle Blogs

Recent comments

March 2011

Falling down the stairs…

If you follow me on Twitter or Facebook, you will know I fell down the stairs last night. My office is upstairs and I often put mail on the stairs to remind me to take it up. I also have a habit of walking around the house with the lights off in the evening. These two factors combined beautifully yesterday and resulted in me launching myself down the stairs with a couple of empty mugs in my hands. The initial assessment was left knee and right elbow were sore and I had some small cuts on my hands and arms from the shattered mugs in my hands. As the adrenaline wore off I noticed more cuts and various bits of my body started to ache.

Everything is OK this morning. My left knee still feels a bit dodgy, but all the cuts were so fine they are barely noticeable now. Apart from that, it’s just an all-over body ache similar to minor whiplash. Fun, fun, fun… :)

Cheers

Tim…




Falling down the stairs…

If you follow me on Twitter or Facebook, you will know I fell down the stairs last night. My office is upstairs and I often put mail on the stairs to remind me to take it up. I also have a habit of walking around the house with the lights off in the evening. These two factors combined beautifully yesterday and resulted in me launching myself down the stairs with a couple of empty mugs in my hands. The initial assessment was left knee and right elbow were sore and I had some small cuts on my hands and arms from the shattered mugs in my hands. As the adrenaline wore off I noticed more cuts and various bits of my body started to ache.

Everything is OK this morning. My left knee still feels a bit dodgy, but all the cuts were so fine they are barely noticeable now. Apart from that, it’s just an all-over body ache similar to minor whiplash. Fun, fun, fun… :)

Cheers

Tim…




First Lord’s Fury…

First Lord’s Fury is the sixth (and final) book in the Codex Alera series by Jim Butcher. The book follows on from where the Princep’s Fury ended.

This book returns to the juggernaut pace of Captains Fury. I mentioned previously that some parts of the series were quite predictable, but that didn’t detract from the enjoyment and expectation. That is also true of this final book. You are pretty sure where you would like things to end up. The question is, how are you going to get there?

Part of me is very sad it’s over and part of me is relieved as I don’t think I could cope if it carried on. It’s an awesome series, but I quite draining because it is so intense. If this were a 38+ series like Discworld, I think I would have to retire on medical grounds… :)

It’s about 4 months until the next Dresden Files book is released, so I think I will have a rest and maybe look at the Earth’s Children series, suggested by @Boneist.

Cheers

Tim…




First Lord’s Fury…

First Lord’s Fury is the sixth (and final) book in the Codex Alera series by Jim Butcher. The book follows on from where the Princep’s Fury ended.

This book returns to the juggernaut pace of Captains Fury. I mentioned previously that some parts of the series were quite predictable, but that didn’t detract from the enjoyment and expectation. That is also true of this final book. You are pretty sure where you would like things to end up. The question is, how are you going to get there?

Part of me is very sad it’s over and part of me is relieved as I don’t think I could cope if it carried on. It’s an awesome series, but I quite draining because it is so intense. If this were a 38+ series like Discworld, I think I would have to retire on medical grounds… :)

It’s about 4 months until the next Dresden Files book is released, so I think I will have a rest and maybe look at the Earth’s Children series, suggested by @Boneist.

Cheers

Tim…




Oracle by Example portal now shows 12g

A quick post… which is a bit interesting…

As I was searching for Exadata viewlets in Oracle By Example portal (http://goo.gl/HjshR) I clicked on the “Advanced Search”

and then filtered by Product Family (Database) and then by Product

to my surprise there was an option for “Database 12g”….

Battle: Los Angeles…

For some masochistic reason you decide to watch Independence Day, realize it’s a steaming pile of crap (of almost Twilight proportions) and decide the only way to make the world a better place is to redo the film properly. What you end up with is Battle: Los Angeles. It’s pretty much the same story.

I’m not saying it’s a great sci-fi film, but it’s pretty darn good. I wasn’t holding out much hope during the first few scenes because the person with the camera seemed to be having a fit. On stationary shots where people were just chatting it looked like the camera was sitting on a washing machine during the spin cycle. Once the action kicked in the camera work seemed much more appropriate, even steady at times.

The feel was very much like that of District 9 and Skyline, which is a good thing in my opinion. Dirty and gritty wins out over Hollywood polish for me. The budget was quite a bit higher than those films, but it had some recognizable actors and everything was so much bigger. It still came in at $5,000,000 under the price of Independence Day, and that was made 14 years ago.

There were a few inevitable bits of cheese and gaps in story development, probably from cuts to bring it just under 2 hours, but it still worked pretty well.

I was surprised to see Ne-Yo in the film, but he did an OK job. If Michelle Rodriguez is one tenth as cool in real life as she is in films, she will be mine. Oh yes! She will be mine! It would be great to have a girlfriend who could beat the crap out of guys if they don’t respect my authoritah:)

Cheers

Tim…




Battle: Los Angeles…

For some masochistic reason you decide to watch Independence Day, realize it’s a steaming pile of crap (of almost Twilight proportions) and decide the only way to make the world a better place is to redo the film properly. What you end up with is Battle: Los Angeles. It’s pretty much the same story.

I’m not saying it’s a great sci-fi film, but it’s pretty darn good. I wasn’t holding out much hope during the first few scenes because the person with the camera seemed to be having a fit. On stationary shots where people were just chatting it looked like the camera was sitting on a washing machine during the spin cycle. Once the action kicked in the camera work seemed much more appropriate, even steady at times.

The feel was very much like that of District 9 and Skyline, which is a good thing in my opinion. Dirty and gritty wins out over Hollywood polish for me. The budget was quite a bit higher than those films, but it had some recognizable actors and everything was so much bigger. It still came in at $5,000,000 under the price of Independence Day, and that was made 14 years ago.

There were a few inevitable bits of cheese and gaps in story development, probably from cuts to bring it just under 2 hours, but it still worked pretty well.

I was surprised to see Ne-Yo in the film, but he did an OK job. If Michelle Rodriguez is one tenth as cool in real life as she is in films, she will be mine. Oh yes! She will be mine! It would be great to have a girlfriend who could beat the crap out of guys if they don’t respect my authoritah:)

Cheers

Tim…




Visitors etc.

Well, I’ve finally reached another “landmark” number in the page views – 2,000,000 views (after four and a half years) – so it’s time for a little statistical summary for comparison with the last landmark.

Looking at just the results for the last 12 months, here are some numbers in different categories.

Page Views:

AWR / Statspack 11,871 Updated from time to time
NOT IN 7,981 Published February 2007
dbms_xplan in 10g 6,672 Published November 2006
Simple Scripts 5,899 Updated from time to time
Cartesian Merge Join 5,335 Published December 2006

Referrers (incoming links)

Google Reader 13,296
forums.oracle.com 10,234 The OTN database forum. A large percentage for reading AWR, index rebuilds, or hints.
Google 6,079 80/20 split between the news groups and searches
oaktable.net 3,691 The Oak Table site. Most from the aggregator
jlcomp.demon.co.uk 3,235 My old web page. Most are from the front page
orana.info 2,330 Eddie Awad’s feed aggregator
dbaspot.com 1,849 A newsgroup history site. Most are for “How to read AWR”

Clicks (places my readers go to)

Oak Table home page 1,926
My old web page 1,377
Nigel Noble’s blog 1,961
Oracle’s Statspack paper(pdf) 1,238
Wolfgang Breitling’s home page 1,057
The 10053 treeviewer download 981
Graham Woods ASH presentation 936
Julian Dyke’s presentation page 929

Incoming Searches

There are harder to count, so I haven’t, but to demonstrate this – I’ve listed some of the most popular searches by the number of different variations that got to the blog, but I haven’t summed the related numbers of page views.

“Jonathan Lewis” / Scratchpad 23 variations
Oracle NOT IN 20 variations
SQL Profiles 18 variations
“some topic” + “jonathan lewis” or “scratchpad” 16 variations
Cartesian join 14 variations
free buffer waits 12 variations
dbms_xplan 12 variations
push_subq 11 variations

Real-Time SQL Monitoring… Update…

Real-Time SQL Monitoring got a lot of air-time when it was released in 11g. I remember being wowed in a number of presentations. What I had failed to notice until recently was a quite interesting update in 11gR2. Previously, the reports always looked a lot prettier in Enterprise Manager than they did in the HTML reports produced by the DBMS_SQLTUNE package. In 11gR2, the introduction of an ACTIVE report means you can now get the EM-style report using the DBMS_SQLTUNE package. Of course, if you are always using EM to look at your SQL monitoring reports, this change is of little value, but if you are using DBMS_SQLTUNE to generate the reports you may want to give it a try because the layout is definitely better. I’ve updated my article on the subject to reflect the changes in 11gR2.

Just goes to show, every time you open the manuals something pops out to make you realize how much you don’t know.

Cheers

Tim…




Real-Time SQL Monitoring… Update…

Real-Time SQL Monitoring got a lot of air-time when it was released in 11g. I remember being wowed in a number of presentations. What I had failed to notice until recently was a quite interesting update in 11gR2. Previously, the reports always looked a lot prettier in Enterprise Manager than they did in the HTML reports produced by the DBMS_SQLTUNE package. In 11gR2, the introduction of an ACTIVE report means you can now get the EM-style report using the DBMS_SQLTUNE package. Of course, if you are always using EM to look at your SQL monitoring reports, this change is of little value, but if you are using DBMS_SQLTUNE to generate the reports you may want to give it a try because the layout is definitely better. I’ve updated my article on the subject to reflect the changes in 11gR2.

Just goes to show, every time you open the manuals something pops out to make you realize how much you don’t know.

Cheers

Tim…