Monday, June 20, 2005

Not enough time in the day

It's been a while since I last post although I do surf and visit the other blogs like Tom Kyte's, Howard Rogers', etc.

I've been busy not with work (after all I am still on parental leave) but with my daughters' school. The school year is winding down and everyone is rushing to get ready for summer and the teachers have been booking field trips, concerts, etc. I find that a lot of the time was spent driving and waiting. The bad thing is that there is no solid block of time to sit back and read. The other thing is probably I need to do better time management but plans do get side-tracked. For example, this morning, I had planned to do something else but got side-tracked with helping a friend resolve some networking issues with his home computers. Oh well. C'est la vie. I am actually looking forward to going back to work and to a more structured lifestyle. :D

Wednesday, June 08, 2005

$10 million

Over this past weekend (June 4th/5th), the British Columbia Children's Hospital did their annual teleton of fund-raising. The funds raised will be used to buy equipment, grants for R & D into causes and cures for illness afflicting children including cancer. It was with great pride that the funds raised this year broke last year's record of $8m plus with slightly over $10m raised! Considering that the Province of BC only has slightly over 4 million folks, I think that's an amazing achievement. Of course, a good portion of donations are from corporations which is also a good sign that corporate citizenship is alive and well.

I was also at a thank you gala at the University of British Columbia last Tues (June 7h) and it was also amazing the amount of money donated to the University to help with funding of R & D projects and to meet the various students who depends on the monies. The President of UBC also explained that the university is turning out more than just highly qualified and talented individuals. One key learning component at UBC is the realization that we are part of the global village and our work and lifestyle should reflect that by contributing to make it a much better world.

Thursday, June 02, 2005

READ ONLY tablespace performance discussion.

Mike Ault yesterday published a set of results on his blog showing the differences in performance between READ_ONLY tablespaces and your normal everyday READ_WRITE tablespaces in Oracle, Are READ_ONLY tablespaces faster as well an article on it with Robert Freeman. This came about as a result of a posting by Tom Kyte on his blog which was a result of an article written by Don Burleson. One of the claims in the article was that read-only tablespace is faster because it bypasses the read-consistency that Oracle uses. The article has since been edited and the claim no longer appear in the article so the discussion surrounding all this might be a moot point. What's frustrating is that there were no indication on the article itself that it has been edited and 'corrections' made. But then DKB is well known for this tactic where he would post and re-edit/correct without documenting that so that his posting/article changes all the time except for those published in hard copy. The irony is that the edited article now refers to Mike's and Robert's article (a matter of "Circular References").

From the results published by Mike and some of the others, I think it is safe to conclude that any performance gains are so minute that it would not make a difference. Where would you use READ ONLY tablespace. I would suggest that if you have static data that are never going to change, locating them on a READ ONLY tablespace reduces the maintenance and support required (both by the database and the DBA).

Wednesday, June 01, 2005

Live 8 - A good start

Sir Bob Geldof is getting together with his high-powered entertainment buddies ago to put together another charity concert, Live 8. This time he is not asking for donations of funds but rather he is asking for time and effort from you and everyone of us to pressure our governments to make a difference to the ongoing famine and poverty