Monday, December 24, 2007

Yahoo Go! Gone

I tried to upgrade Yahoo! Go on to my Blackberry 8820 (4.3) and I got App Error 200 after it installed. I searched around and the only option I found was to wipe the handheld and reactivate. I had no backup. With a prayer on my lips and a promise that I would take a backup before trying anything adventurous, I tried connecting it to the Desktop Manager and miraculously it did connect. I located Yahoo! Go and removed it. This seemed to solve the issue, my 8820 was back in business and I promptly took a backup. Whew!!
I like Yahoo! Go, its interface and especially its navigation features better than the new Google Maps so I tried installing it again, with the confidence of a backup ( that I never tried to restore) and Desktop Manager support. I got the same error, but this time I was able to get the 8820 online with a simple reboot.
So until the issue is fixed, Yahoo! Go is gone from my blackberry.

Update:
it seems that on subsequent install, I still got the app error, but after the reboot Yahoo! Go was successfully installed and usable.

Friday, December 14, 2007

Day 2 of performance tuning

Another long night, but there is hope thanks to sophisticated tools like cmd prompt, sqlplus, explain plan and Google (it is just a means to get to AskTom).

It seems that my updates on views could not push predicates because of the use of rownums. As usual found an
Ask Tom article that explained it. As usual it took a couple of reads to make its mark. (All my fault!). Changed the statement and everything was back on track.

Why am I updating views? Well it so happens that the views were tables in their previous incarnation and now they are reborn to take part in a grand home-grown auto partitioning scheme.
As most experts would probably put it, those 4 words should never be uttered in the same sentence. Well it is a long story and the database has quieted down so I will have to save it for another day.

Thursday, December 13, 2007

How do I start writing a blog?

How do I start? What if it sounds lame? Have these views been already expressed in boring detail by every other blogger? Am I too controversial? Too arrogant? or so boring as to have no views? Am I using the corrrect phrases? Am I grammatically correct? I am not an expert on anything so am I providing value?

I should be reading How to write a Better Blog
or begin with How to Write a Blog

How did I get into this? I am performance tuning my Oracle database and bored to death waiting for the queries to return. The results tell me that, I have long nights ahead. Look forward to more of this @#$$%$.